Question: 1. Physical Model Physical Table Representation: 1. Convert the logical model to a physical model using a table format (not implementation) a. Create a table

 1. Physical Model Physical Table Representation: 1. Convert the logical model

1. Physical Model Physical Table Representation: 1. Convert the logical model to a physical model using a table format (not implementation) a. Create a table for each physical database table. Include key type, optionality, column name, data type, length 2. Implementation of Physical Model Create Database Tables: 1. Construct CREATE statements for each table 2. Include IDENTITY and SEQUENCE columns (optional) Identify Business Rules/Database Constraints: 1. List the physical database rules/constraints for: NOT NULL DEFAULT Primary keys Unique keys Foreign keys Check constraints b. List at least 3 business rules that must be programmed 2. Implement the constraints into the database creation statements 3. Construct INSERT statements and populate each table with at least 10 rows Constraint Testing: Test at least 5 constraint and provide documentation that each constraint works

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!