You have been hired by a Social Media firm (similar to Facebook) to develop a database from scratch. The firm’s revenue comes from advertisement and market place.
- Details about any assumptions you make (10 points)
- SQL Code to create the mini world, entity (tables) with all the constraints (15
points) - SQL Code to insert, delete and modify the tables: Insert, delete and modify for
each table. Take into account the constraints (15 points). - Sample SQL codes (minimum 2) to retrieve data from tables (10 points)
FAQs:
Q0) What is this firm?
You need to come up with it. Use can use Facebook as an example
Q1) Where do I get the data to insert in the tables?
Make them up. It is your database. But mind the domain constraints
Q2) What format do I submit my project?
The instructor should be able to copy the code and run it. Word is most preferred.
Q3) Can put screen shots?
Sure. If helps to explain your mini world.
Q4) 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 difficult.
Q5) How detailed should the explanation of my assumptions need to be?