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