Problem
From a high-level standpoint, this final project consists of the following steps:
• Selection of a database (The database would be fine if it comes from an authentic source. You can download any reasonable size of database from Microsoft access or choose to download it from other Referral sources you like)
• Identifying the requirements for the database based on the purpose for the database and the data to fill the database. In this they were doing something kind of reverse engineering. In other words you have the database ready and now you're being asked to draw on the requirement for this database. Here you need to compile a list of requirements that leads to creating an identical database.
• Database design based on the requirements for the database, create the physical database, and load data into the database. Practice by creating the physical and the ER model for the database based on your understanding of the requirements. Here basically you want to test your ability in creating the model that the present the actual database you got from the search
• After loading the database, carry out sample queries that would be performed on the actual database. Show the results of the sample queries. For this particular question you need to create some simple queries Of your choice after you have uploaded the database into SQL.