subject

You will form groups of 4-5 to develop a database system a contact tracing system. You will design the database, insert some sample data, and implement a set of required features. Each feature will be implemented as one or more Oracle PL/SQL procedures/functions. You do NOT need to write a graphic user interface. You also need to provide statements to execute your procedures. Assumptions: You can make the following assumptions in this project. 1. The database stores information about houses, each with a house ID, address, and zip code. 2. The database stores information about person, including person ID, house ID where the person lives, person name, phone number, and status where 1 means currently tested positive (i. e., the most recent test result is positive), 0 means currently tested negative (i. e., the most recent test result is negative), and null (no test so far so status is unknown). 3. The database stores information about a person's all past tests, including person ID, test date, and result (1 means positive and 0 negative). 4. The database stores information about events (could be gathering, party, etc.). Each event has an event ID, event name, date, and address. 5. The database stores information about a person participated in an event. 6. The database stores information about flights, including flight ID, flight date, flight number (a varchar type e. g., 'DL 345' is a delta 345 flight). 7. The database stores IDs of people on a specific flight.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 19:40
Write the quartstogallons java class that declares a named constant to hold the number of quarts in a gallon (4). also declare a variable to represent the number of quarts needed for a painting job, and assign an appropriate value—for example, 18. compute and display the number of gallons and quarts needed for the job. display explanatory text with the values, for example:
Answers: 2
question
Computers and Technology, 22.06.2019 10:40
"it security policy enforcement and monitoring" respond to the following: describe how monitoring worker activities can increase the security within organizations. describe the rationale that managers should use to determine the degree of monitoring that the organization should conduct. explain the extent to which you believe an organization has the right to monitor user actions and traffic. determine the actions organizations can take to mitigate the potential issues associated with monitoring user actions and traffic.
Answers: 3
question
Computers and Technology, 24.06.2019 10:00
Each time you save a document, you will need to type in the file type in which it should be saved you can select the save button to save it with the same file name if it has been previously saved you will need to select the location to save the file you will need to use the save as dialog box
Answers: 1
question
Computers and Technology, 24.06.2019 12:40
Match the feature to the network architecture. expensive to set up useful for a small organization easy to track files has a central server inexpensive to set up difficult to track files useful for a large organization does not have a central server client- server network peer-to-peer network
Answers: 3
You know the right answer?
You will form groups of 4-5 to develop a database system a contact tracing system. You will design t...
Questions
question
Mathematics, 11.05.2021 19:20
question
Mathematics, 11.05.2021 19:20
Questions on the website: 13722360