Question

create a database in SQL using the following information: We are creating a crime mystery database, which takes place at a daycare. A baby has stolen a cookie. Using the database, the user must find who that baby is. One of the daycare assistants reported the crime, Janine. The crime occured on 3/17/2023. We've got four tables: Daycare employees, Interviews, Babies, Attendance. Here are the columns for each table: Interviews: Primary Key( ID), EMP_ID, Crime-type, Interview, Date; Attendance: Primary Key(ID), Date, Foreign Key(Baby_id); Babies: Primary Key(ID), First, Last, Hair color, eyes; Daycare Employees: ID, First, Last

Answer 1

To create a SQL database for the crime mystery daycare scenario, you would need to create four tables: Daycare Employees, Interviews, Babies, and Attendance. Each table would have specific columns to store relevant information.

Step-by-step explanation:

To create a database in SQL for the crime mystery database at the daycare, you would need to create four tables: Daycare Employees, Interviews, Babies, and Attendance. The Interviews table would include columns such as ID, EMP_ID, Crime-type, Interview, and Date. The Attendance table would have columns for ID, Date, and the Foreign Key Baby_id. The Babies table would include columns for ID, First Name, Last Name, Hair Color, and Eye Color. Lastly, the Daycare Employees table would have columns for ID, First Name, and Last Name.