zip

[SOLVED] SQL Course Project

30.00 $

Category: SQL

Click Category Button to View Your Next Assignment | Homework

You will receive the following solution file(s) instantly after successful payment:

Final-Project-f2ay2k.zip ()

Assignment Instructions Updated Recently? Submit Below and we will provide new Solution!

Submit New Instructions

🔒 Securely Powered by:

Secure Checkout

Description
Downloads

Rate this product

Select one of the following topics:
1. COVID-19 vaccination delivery to the population of a small town
2. A remote conferencing system, such as Zoom
3. Polling place (קלפי) in the upcoming election
4. Assembly line for a bicycle factory

Foundations – prepare the following:
1. A general description of the system and the data needed for managing it
2. Requirements for the system – what is the database for
3. Define two user types for the system
4. Describe the entities in the database (at least 6) and the relationships between them
5. Create an ERD for your system

Creating the database
1. Create the database with CREATE commands
2. Fill the database with data using either INSERT commands or UPLOAD from a file

Querying the database
1. Write at least twelve SELECT commands to be performed by the user. Credit will be given for complexity of the queries
2. Write at least four INSERT/UPDATE/DELETE commands to be performed by the user Be sure to include commands for both users defined in 2(c).

Extras: Items 1-4 can earn you at most a grade of 90. To get to 100 you have to go beyond a. Triggers
1. Database security
2. Other exciting features that we learned or that you researched

What to turn in:
1. A 10-15 minute presentation describing your project, given in the last week of class
  1. Mandatory attendance in the last week
2. A folder containing all the components described in sections 1-5
  1. Turned into moodle

Final-Project-f2ay2k.zip

You're viewing: [SOLVED] SQL Course Project 30.00 $