[Solved] SQL Course Project

Whatsapp Us

Scan or Click here to open the chat!%s

[Solved] SQL Course Project

$25

File Name: SQL_Course_Project.zip
File Size: 169.56 KB

SKU: [Solved] SQL Course Project Category: Tag:
5/5 - (1 vote)
  1. 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
  1. 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
  1. 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
  1. 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).
  1. 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
  1. 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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related products

Shopping Cart
[Solved] SQL Course Project
$25