CSC 240: Week of 4/12/10

CSC 240: The Week beginning Apr. 12

Homework:
- Submit an ER diagram for your project. Your project should have
  - At least four entities, list the important properties, indicate a primary key
  - At least one one-to-many relationship
  - At least one many-to-many relationship.
  - State the relationships in two ways, such as, "A Congress person may be on many committees" and "A committee consists of many congress persons."
- Read Chapter 11 of Database Nation (Simson Garfinkel) and write a one-page summary (in your own words) of or reaction to what you read.
Due: Apr. 19

There is one more test and a final.
Monday:

Command Line Oracle Lab
Wednesday:

More Command Line Oracle Lab uses pubs2002.accdb and Pubs_Script.sql
Friday:

Use the SQL script Charter.sql to create the design of the tables for an Oracle version of Ch06_AviaCo.accdb. Then use the method from Wednesday's lab to create a(n) SQL Insert scripts to enter the data for the Customer and Charter tables. Send a screen capture of your Insert script as well as a query showing the data you inserted.

In Customer be careful or Amy O'Brian. Also be careful of numbers with commas in them. Use Excel's cell formatting to write the numbers without commas before making your csv file.

In Charter be careful of the dates and the numbers with commas. A trick for dates is to use the Excel formula

=CONCATENATE("'",TEXT(D3,"MMM-DD-YYYY"),"'")

where D3 would be the reference to the Excel cell containing the date in question.

Use any remaining time this period to catch up or to work on your project.