provide the Data Definition Language (DDL) needed to create tables, attributes, primary and foreign key constraints, any other constraints needed on a single attribute or across attributes to ensure only valid data is entered, and indexes or other structures needed to make the performance adequate for the common and urgent operations.
Write the SQL code to perform each of the common and urgent activities. Explain how you expect it to use the defined structures efficiently.
Describe what tools would be available in a commonly used database to determine if the database is following the execution plan you envision. for a student class database i already have
12 freelancers are bidding on average $384 for this job
I am a Microsoft SQL Server expert and I am readily available to realize your goal on this project Relevant Skills and Experience DDL and DML SQL Microsoft SQL Server Windows OS Proposed Milestones $450 USD - DDL