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, 22.06.2019 02:00
Aletter or menu command that starts an action when the user presses the designated letter and the alt key together is called what?
Answers: 1
question
Computers and Technology, 22.06.2019 10:30
Auniversity wants to install a client-server network. which feature do you think is important for them as they set up the network? sending email blocking multiple people to use the same file low security low set up cost limited access to files
Answers: 1
question
Computers and Technology, 23.06.2019 10:00
Hey i just logged on and one of the moderators deleted a bunch of my answers to questions, even though the answers were right and the people it doesn't make sense but if anyone wants to talk about anything just message me lol (this is super random lol)
Answers: 1
question
Computers and Technology, 23.06.2019 19:00
Acompany is hiring professionals for web designing. the firm is small with few resources. they want employees who possess problem-solving skills and can independently carry out responsibilities. which kind of employee should they select?
Answers: 2
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, 01.12.2021 23:40
question
English, 01.12.2021 23:40
question
Mathematics, 01.12.2021 23:40
question
Mathematics, 01.12.2021 23:40
Questions on the website: 13722367