Step 2: Design ER diagram College_name idCollege_name INT College_address VARCHAR(4.. College_phone VARCHAR(45) Indexes Student Student number...

Transcribed Image Text:

Step 2: Design ER diagram College_name idCollege_name INT College_address VARCHAR(4.. College_phone VARCHAR(45) Indexes Student Student number INT Student First Last VARCHAR(... Student phone VARCHAR(45) Indexes Campus1 Campus_name INT -Campus Jocation VARCHAR(... Campus_phone VARCHAR(45) College_name_idCollege_na.. Indexes Student has_Course Student Student number INT Course Course code INT Course Department Department_name INT Course Department Campus1_Campus_name INT Indexes Step 3: Write DDL statements Department Department name INT Department Jocatoin VARCHAR( Department phone VARCHAR(45) Cam pus 1 Campus_name INT Campus1 Campus_namel INT Indexes Course Course_code INT Course duration VARCHAR(45) Course name VARCHAR(45) Department Department name... Department Campus1_Campus. Department Department name1.... Department Campus1_Campus_ Indexes C 3 of 3 Step 3: Write DDL statements Referring to the model created in Step 2, write the SQL DDL statements to perform the following: ALGONQUIN Centre for Continuing COLLEGE & O B: Create database 'Assignment1' Create all tables: - o Include primary and foreign keys O Choose the datatype and length for each column as you see fit O All primary keys, foreign keys must be specified in the CREATE TABLE statement O All DDL statements must be written manually. Do not reverse-engineer the SQL from MySQL Workbench. Apply formatting to the SQL statements. Refer to this URL as a reference on formatting: https://learnsql.com/blog/24-rules-sql-code-formatting-standard/ Make sure all DDL statements execute without error 39 + 80% (7 (6 1 H W View a 121 2 Step 2: Design ER diagram College_name idCollege_name INT College_address VARCHAR(4.. College_phone VARCHAR(45) Indexes Student Student number INT Student First Last VARCHAR(... Student phone VARCHAR(45) Indexes Campus1 Campus_name INT -Campus Jocation VARCHAR(... Campus_phone VARCHAR(45) College_name_idCollege_na.. Indexes Student has_Course Student Student number INT Course Course code INT Course Department Department_name INT Course Department Campus1_Campus_name INT Indexes Step 3: Write DDL statements Department Department name INT Department Jocatoin VARCHAR( Department phone VARCHAR(45) Cam pus 1 Campus_name INT Campus1 Campus_namel INT Indexes Course Course_code INT Course duration VARCHAR(45) Course name VARCHAR(45) Department Department name... Department Campus1_Campus. Department Department name1.... Department Campus1_Campus_ Indexes C 3 of 3 Step 3: Write DDL statements Referring to the model created in Step 2, write the SQL DDL statements to perform the following: ALGONQUIN Centre for Continuing COLLEGE & O B: Create database 'Assignment1' Create all tables: - o Include primary and foreign keys O Choose the datatype and length for each column as you see fit O All primary keys, foreign keys must be specified in the CREATE TABLE statement O All DDL statements must be written manually. Do not reverse-engineer the SQL from MySQL Workbench. Apply formatting to the SQL statements. Refer to this URL as a reference on formatting: https://learnsql.com/blog/24-rules-sql-code-formatting-standard/ Make sure all DDL statements execute without error 39 + 80% (7 (6 1 H W View a 121 2