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 21:30
Im doing this last minute and literally none of my neighbors or people that my dad works with use excel so if anyone could me make up an example
Answers: 1
question
Computers and Technology, 23.06.2019 02:30
These factors limit the ability to attach files to e-mail messages. location of sender recipient's ability to open file size of file type of operating system used
Answers: 2
question
Computers and Technology, 23.06.2019 13:00
Donnie does not have powerpoint. which method would be best for elana to save and share her presentation as is? a pdf a doc an rtf a ppt
Answers: 3
question
Computers and Technology, 24.06.2019 08:30
Formatting rows and columns is similar to cell formatting. in an openoffice calc spreadsheet, you can format data entered into rows and columns with the of the rows and columns options. you can insert rows and columns into, or delete rows and columns from, a spreadsheet. use the insert or delete rows and columns option on the insert tab. alternatively, select the row or column where you want new rows or columns to appear, right-click, and select insert only row or only column options. you can hide or show rows and columns in a spreadsheet. use the hide or show option on the format tab. for example, to hide a row, first select the row, then choose the insert tab, then select the row option, and then select hide. alternatively, you can select the row or columns, right-click, and select the hide or show option. you can adjust the height of rows and width of columns. select row and then select the height option on the format tab. similarly, select column, then select the width option on the format tab. alternatively, you can hold the mouse on the row and column divider, and drag the double arrow to the position. you can also use the autofit option on the table tab to resize rows and columns.
Answers: 1
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, 26.03.2021 19:50
question
English, 26.03.2021 19:50
question
Mathematics, 26.03.2021 19:50
question
English, 26.03.2021 19:50
question
Mathematics, 26.03.2021 19:50