Question: IST210: Organization of Data Assignment 6: Database Design (Chapter 5) Problem Suppose we already have the following E-R diagram for Grand Travel Airlines from Assignment


IST210: Organization of Data Assignment 6: Database Design (Chapter 5) Problem Suppose we already have the following E-R diagram for Grand Travel Airlines from Assignment , convert this E-R diagram to a database. 1. Specify all tables. A table should be represented in the format as TABLENAME(Column1, Column2, Column3, Column4) Note: primary key and foreign keys should be annotated using underline and italic font. 2. Specify the attribute properties for each table. For each table in Question 1, you should draw a form to specify the properties, including Column Name, Data Type, Key, Required, and Remarks
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
