Using the relations that you defined and normalized as part of the Unit 4 Programming Assignment, create
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the relations that you defined and normalized as part of the Unit 4 Programming Assignment, create the SQL DDL statements necessary to implement your database schema as an OpenOffice database. You may also implement your database in MySQL, IBM DB2 Express, Microsoft Access, SQL Server if you have access to these database systems. Your assignment must include a document that contains all of the SQL statements that you created and a screenshot that shows the structures that you implemented in the database of your choice. Your DDL statements must accommodate the following elements:
- Create statements to create tables from the entities defined as part of the Unit 4 assignment
- Appropriate use of Null (and Not Null) parameters to ensure data validity
- Appropriate use of constraint clauses to implement appropriate referential integrity
- Use of data types and formats that is appropriate for the data in your database schema.
- Appropriate use of keys including automatic generation of key values if appropriate
Unit 4 ER Diagram:
Related Book For
Posted Date: