- Select one of the following topics:
- COVID-19 vaccination delivery to the population of a small town
- A remote conferencing system, such as Zoom
- Polling place (קלפי) in the upcoming election
- Assembly line for a bicycle factory
- Foundations – prepare the following:
- A general description of the system and the data needed for managing it
- Requirements for the system – what is the database for
- Define two user types for the system
- Describe the entities in the database (at least 6) and the relationships between them
- Create an ERD for your system
- Creating the database
- Create the database with CREATE commands
- Fill the database with data using either INSERT commands or UPLOAD from a file
- Querying the database
- Write at least twelve SELECT commands to be performed by the user. Credit will be given for complexity of the queries
- 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
- Database security
- Other exciting features that we learned or that you researched
- What to turn in:
- A 10-15 minute presentation describing your project, given in the last week of class
- Mandatory attendance in the last week
- A folder containing all the components described in sections 1-5
- Turned into moodle
- A 10-15 minute presentation describing your project, given in the last week of class
Reviews
There are no reviews yet.