-Sample Data and Queries.
1-Empty Gates.
2-Available Spots.
3- Gate Listing.
4-Invoice Generation.
5-Gate Assignment Errors 1.
6-Gate Assignment Errors 2.
7-Fixing the Gate Size.
Category: SQL
While managers don’t often have to create actual database systems, they do have to help with the design and leading the vision they have for the system. You can do this in software you already have on your computer (i.e. Microsoft Excel). For this assignment, you will develop a simple data model for a student database that includes student contact data, student demographic data, student grades data, and student financial data. Submit the table here. Name your spreadsheet: last name Student Database (ex. Jones Student Database)
Additional Directions:
Using Excel create a spreadsheet with each table on a separate tab (you may combine information to create your tables)
Determine the data attributes that should be in each table
Identify the primary key for each table
Identify the foreign key for each tableWhile managers don’t often have to create actual database systems, they do have to help with the design and leading the vision they have for the system. You can do this in software you already have on your computer (i.e. Microsoft Excel). For this assignment, you will develop a simple data model for a student database that includes student contact data, student demographic data, student grades data, and student financial data. Submit the table here. Name your spreadsheet: last name Student Database (ex. Jones Student Database)
Complete a write-up for the following questions
A) Identify all of the database design steps and describe each. Highlight the value of each step. Each step and description should be approximately 200-300 words
B) Explain how the bottom-up design approach differs from the top-down design approach. Which approach do you believe should be used to design a simple database with a relatively small number of attributes and why?