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 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
Get step-by-step solutions from verified subject matter experts
