Question: 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

  • 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.

I think I am almost done with this but would like someones help to complete this table using my design, so I can compare my table with. 

Artist ARTIST_ID INT PK Name Amount Address Phone Art ART_ID INT PK 

Artist ARTIST_ID INT PK Name Amount Address Phone Art ART_ID INT PK Cost Date Size Genre LOCATION_ID INT FK ARTIST_ID INT FK Location LOCATION_ID INT PK Area Location

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!