Reference no: EM131504688

Assignments

Individual: Database Creation

The following assignment is based on the database environment designed in the Week Three Individual Assignment.

Your database project must meet the following assessment requirements:

• Create a database using professional principles and standards.

• Use a relational database software application to develop a database implementing the logical design into a physical design.

• Use an Oracle database to create the normalized physical database including tables, columns with data types, primary keys, constraints, etc.

• Create a minimum of ten rows of test data in each table.

Submit an .sql file with the scripts needed to create tables with keys and to insert test rows, etc., into the tables and submit to the Assignment Files tab.

Learning Team: W4 - Status Update

Continue working on your Learning Team Database and Presentation due in Week Five. Design your database including the creation of an ERD, identifying primary and foreign keys, determining the appropriate types for database attributes, determining necessary constraints, and normalizing the database to at least the 3rd Normal Form. Use the logical database design to create the physical database. Populate the database with test data using the requirements outlined.