Implement the logical database design for Lakeshore hospital from the second assignment by using Data Definition Language (DDL). For your convenience, I have included the relational schema (see last page) for Lakeshore Hospital that is needed. Please use to this relational schema when you create a script file (text file) that contains the CREATE TABLE definition for each of the 18 relations in the schema. If a table has one or more foreign keys, include in your CREATE TABLE definition the referential integrity constraint(s) that references the corresponding primary key(s) in another table. Please use Notepad to create this script file. As an example, suppose that you want to create a table for the relation LocalDoctor. The DDL would be as follows:

Create Table LocalDoctor

(

Dr_ID Text(10) Not Null,

Dr_Name Text(30) Not Null,

ClinicNo Int,

Dr_Address Text(50),

Dr_Phone Text(12),

Primary Key (Dr_ID)

)

Submit a script (text) file as well as the resulting database file. The script file contains the DDL for each relation shown in the relational schema on the last page and the database file contains the created tables. Script will be tested in Microsoft Access.