Question

Please answer. You have been hired by "Milton, a local hotel to develop a database from scratch. Your submission has to include the following (Please see the attached sample project to get an idea what needs to submitted) 1. ER Diagram or Relational Model 2. SQL Code to create the mini world, entity (tables) with all the constraints (15 points) 3. SQL Code to insert, delete and modify the tables: Insert, delete and modify for each table. Take into account the constraints (15 points). 4. Sample SQL codes (minimum 2) to retrieve data from tables (10 points)

          Please answer. You have been hired by "Milton, a local hotel to
develop a database from scratch.
Your submission has to include the following (Please see the
attached sample project to get an idea what needs to submitted)
1. ER Diagram or Relational Model
2. SQL Code to create the mini world, entity (tables) with all the
constraints (15 points)
3. SQL Code to insert, delete and modify the tables: Insert,
delete and modify for each table. Take into account the
constraints (15 points).
4. Sample SQL codes (minimum 2) to retrieve data from tables
(10 points)

Please answer. You have been hired by "Milton, a local hotel to
develop a database from scratch.
Your submission has to include the following (Please see the
attached sample project to get an idea what needs to submitted)
1. ER Diagram or Relational Model
2. SQL Code to create the mini world, entity (tables) with all the
constraints (15 points)
3. SQL Code to insert, delete and modify the tables: Insert,
delete and modify for each table. Take into account the
constraints (15 points).
4. Sample SQL codes (minimum 2) to retrieve data from tables
(10 points)

Added by Joseph S.

Question

Please give Ace some feedback