This needs to be done on notepad. It has specific directions and must be checked in access to make sure it works.

 

Page1of3Submission:One txt file (with extension .txt) which contains SQL statements (the DataDefinition Language – DDL) to create 18 tables.Problem StatementUsing the knowledge about Data Definition Language of SQL, create 18 database tablesbased on the Lakeshore Hospital’s relational schema which can be found on the last pageof this document.Use this relational schema as your reference to create the DDL.Type the DDL statements (i.e. the statements to create the 18 tables) in a Notepador WordPad text editor which is available in Microsoft Windows operatingsystem.Save and name the DDL according to your first and last name. The file extensionshould be .txt.Use your judgment to specify an appropriate data type for each field (column) ofthe tables.Be sure to specify a primary key, either simple or composite primary key, for eachtable.Be sure that the data type of a foreign key is the same as that of its correspondingprimarykey.Note,however,ifthedata typeofaprimarykeyisanAutoIncrement, the data type of its corresponding foreign key should be Number(Long Integer).You may want to test each of the create table statements by executing it usingMicrosoft Access. (Note: Microsoft Access can only execute the tables one at atime.)Example on how to create four tables (which were typed usingNotepad/Word) and test/execute them in Microsoft Access:1.Type the create table statements for tables: Customer_t, Order_t, Product_t, andOrderLine_t using Notepad or Wordpad. The statements are as follows:Create Table Customer_t(IdAutoIncrement Not Null,FirstNameText(20) Not Null,LastNameText(20),

 

Attachments:

• 1496033756-Solutions file.docx