Question: create a physical design for the database in the form of a SQL script. A SQL script is a plain text file that contains a

create a physical design for the database in the form of a SQL script. A SQL script is a plain text file that contains a series of SQL statements and is saved with the sql as the extension (file ends .sql). Your script file should contain: All of the SQL statements required to create the database and tables. Primary key and foreign key constraints Any indexes that you think are necessary (a minimum of one additional index). Remember that indexes for primary keys and foreign keys are automatically created by MySQL. Statements that insert at least 3 records into each table Along with the SQL script, include, in this, repository, a document (Word, PDF, Google Doc, MarkDown) that justifies the decisions that you made regarding relations, attributes, attribute types and indexes.

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!