"SQL Developer" Database Development Project

Plan, Design, and Create a database

- Design and develop a database. - Complete the following problems. Place each answer AND screen output in a text file.

Your database MUST CONTAIN at least 4 tables!!

At least two tables containing at least 5 records (so your database will contain enough information for queries).

• All tables containing at least one record.
• At least 2 tables should contain at least 4 fields.
• Include at least 2 number fields somewhere in your database. We will use these for calculations!
• At least 1 table should contain a date field (which may or may not be used for calculations)!

1. Write a short narrative describing the database (what is its purpose). Two or three sentences are adequate.

2. Develop an Entity Relationship Diagram of your database. You can sketch it on paper.

3. Develop the schema of your entire database (all 4 + tables). Remember, this is what the data will look like (use Notepad). 4. Determine the appropriate constraints for ALL fields in ALL tables. You should have 4 pk's, probably 3 fk's, at least 1 (one) nn's, at least 1 (one) cc's, and at least 1 (one) uk's (the primary key DOES NOT meet the 1 uk and 1 nn requirement).

Primary Key Foreign Key Check Condition NOT NULL other than one NOT NULL ignore NOT NULL's throughout Unique

5. Determine the appropriate column definition for each field in each table

6. Write the SQL scripts to create all Tables. Include all Constraints you identified in question 5 and 4.

7. Build your tables in Oracle. Show your SQL statements on the document you submit. Verify the successful creation of each table (use the DESCRIBE command to show the table, cut and paste screen output into your project document.