COVID TRACING DATABASEAssumptions:You can make the following assumptions in this project.The database stores information about houses, each with a house ID, address, and zip code.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).The database stores information about a person's all past tests, including person ID, test date, and result (1 means positive and 0 negative).The database stores information about events (could be gathering, party, etc.). Each event has an event ID, event name, date, and address.The database stores information about a person participated in an event.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).The database stores IDs of people on a specific flight. Need this code in PL/SQL for Procedures and Functions, URGENT!! Feature 5: Enter a new event including date, name and address. First check whether the same event exists with the same name, date and address. If so, print a message 'the event already exists'. Otherwise insert a row into event table and print out event id.Feature 6: Print out people's names, phone numbers, and zip code for those whose current status is positive. Finally print out number of people tested positive per zip code.

Answered: The database stores information about…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

COVID TRACING DATABASE

Assumptions:

You can make the following assumptions in this project.

The database stores information about houses, each with a house ID, address, and zip code.
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).
The database stores information about a person's all past tests, including person ID, test date, and result (1 means positive and 0 negative).
The database stores information about events (could be gathering, party, etc.). Each event has an event ID, event name, date, and address.
The database stores information about a person participated in an event.
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).
The database stores IDs of people on a specific flight.

Need this code in PL/SQL for Procedures and Functions, URGENT!!

Feature 5: Enter a new event including date, name and address. First check whether the same event exists with the same name, date and address. If so, print a message 'the event already exists'. Otherwise insert a row into event table and print out event id.

Feature 6: Print out people's names, phone numbers, and zip code for those whose current status is positive. Finally print out number of people tested positive per zip code.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions