Attached are the instructions for this assignment and sample DDL given by teacher on how our script is supposed to look. Teacher wants it submitted as a "script file". I need this by Monday morning at 10:00.

 

IDS 410 – Business Database TechnologySpring 2016Individual Assignment #3 (database implementation)Database Implementation for a Simple Restaurant SystemAssigned Date: February 25, 2016.Due Date: March 8, 2016Problem StatementFor the third assignment, you will use the Data Definition Language (DDL) to create ten Microsoft Accesstables. Using Notepad, please create a script (text) file that contains CREATE TABLE definition for each of theten relations in the Simple Restaurant’s relational schema, which I have included on the last page. Please usethis relational schema as your reference to do the Create Table statements. Use the following format to nameyour script file: yourNetidHwk3.txt. If your UIC email address is abc@uic.edu, your Netid would be abc andtherefore you should name your script file abcHwk3.txt.To get started, I have includedsampleDDL statements (see below) to create four tables: Customer_t, Order_t,Product_t, and OrderLine_t. You might want to test them by executing each of them in Microsoft Access.Notethat you do not need to submit this four sample DDL statements.Sample Data Definition Language Statements to create tables using Microsoft Access. Follow these steps:1.Launch Microsoft Access 2013 or Access 2010 and create a blank database. Name the database file asfollows: SampleDB2.Click the Create tab and select Query Design.3.Click the Close button on the Show Table window.4.Be sure the Design tab is selected. Select SQL View.5.Copy the Create Table Customer_t statement below and paste it on the Query1 window.6.Be sure the Design tab is selected. Click the Run button.7.At this point, the Customer_t should have been created.8.Repeat steps 5 and 6 above to create Order_t, Product_t, and OrderLine_t tables.Create Table Customer_t(IdAutoIncrement Not Null,FirstNameVarchar(20) Not Null,LastNameVarchar(20),Primary Key(Id));Create Table Order_t(IdAutoIncrement Not Null,OrderDateDateTime Not Null,CustIdInt Not Null,Primary Key(Id),Foreign Key(CustId) References Customer_t(Id));Create Table Product_t(IdVarchar(10) Not Null,NameVarchar(30) Not Null,DescriptionVarchar(30),FinishVarchar(30),UnitPriceCurrency Not Null,Primary Key(Id));

Attachments:

• 1495786892-hwk3_ids410_sp2016.pdf