Question: I need help with this: The following assignment is based on the database environment designed in the Week Three Individual Assignment. Your database project must
I need help with this:
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.
PK Customers. Customer_ID Customer_Name PK HO Customer Address Customer_Telephone PRODUCT Item ID Item_Genre Item Value item Name UPC_Number EMPLOYEE O+ OH PK Employee_ID PK Employee_Name STORE PAYMENT PK Payment_ID FK 1 Item ID FK 2 Employee_ID Date date/Time Payment details Total_Sum Store_ID Store Loc
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
