Question: Just need an example, non - libruary please Data Schema: The term project involves designing and implementing a database system for an organization. Each student

Just need an example, non-libruary please
Data Schema:
The term project involves designing and implementing a database system for an organization. Each student has
to work individually in this project. The term project is made up of a series of four deliverables, each building
towards the finished product. Please remember that all deliverables must be submitted by midnight of the class
day on the date they are due. Late deliverables will penalize according to the late work policy, unless prior
arrangements have been made.
The project requires building a database application for a real-world scenario of your choosing. Some examples
include: books, movies, music, computer games, geographical locations, genomic sequences, white water rafting
resources, flights, etc. Note that you cannot choose the University database that is used in the text book nor
the Customer-Invoice schema that is used in assignment 3. Try to pick an application that is relatively
substantial, but not too big. For example, you might want your design to have in the range of 5 to 8 or so entities.
You will design schemas for the database, and you will create an actual database using the MySQL relational
Database Management System. You will populate the database with sample data, write interactive queries and
modifications on the database, and develop user-friendly tools for manipulating the database.
Step 1: What to submit?
You are required to submit a one-page project description of your application. This is an initial, but reasonably
well-thought out, one-page description of the database application you propose to work with throughout the
course. Note that you cannot choose the University database that is used in the text book nor the Customer-
Invoice schema that is used in assignment 3. You may state any assumptions you would like to make. Make sure
your submission includes the following:
1- One paragraph description of your application.
2- An initial list of tables (at least 5 tables) that will be used in order to represent your application.
3- For each table, propose an initial set of attributes (or fields).
4- The explanation of at least 5 scenarios for queries that need to be answered using your database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!