CSCI 352 DBMS Proiect

NOTE: This is an individual project. You have been hired by 'Milton", a local hotel to develop a database from scratch. Your submission has to include the fol lowingiPlease see the attached sample Droject 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] What is in the sample proiect report? This sample project report was submitted by one of the students from a previous class. The mini—world was a Social Network company I have only included the part of the project that is relevant, ?g 01} What is this firm? Using the suggestion above, please come up with it. 02} Where do | get the data to insert in the tables? Please come up with it. 03} What format do | submit my project"? The instructor should be able to copy the code and run it. SQUtxt is most preferred. Q3} Can put screen shots? Sure. If it helps to explain your mini world. 04} What if there are no constraints in my database? That means your tables are not related by the schema. Not a good design, since maintaining a valid state is almost impossible.

pur-new-sol

Related Questions