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).
Assumptions:
- 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.
- SQL statements to create database tables and to insert some sample data (at least 3 rows per table). Please include drop table and drop sequence statements before create table, create sequence and insert.
- Specification for each required feature. The specification should include a description of input parameters and output (usually printing a message), and a few test cases (normally there should be one normal case and a few special cases). You don’t need to implement any of these procedures at this point.
Given:
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
