Using Mysql Im supposed to 1 Create a new databaseschema 2 C

Using Mysql I\'m supposed to..

1. Create a new database/schema

2. Create tables to match the entities in your ERD. (Specify table names, column names and data types. Make sure to capture primary and foreign keys and any other constraints)

2. Populate each table with atleast 20 rows.

3. Create a data dictionary to describe the database design ( This basically describes each table, columns and characteristics).

*** I just need to create tables for The Student Borrow & Faculty Borrow entitys only***

Please help me with this if you can! I\'m not sure how to do it! Thanks.

Student Borrow Reservation Cade FX StudentID Resources Student ResoucelD PK RresoucelD PK StudentlD FX LastName Date FirstName TimelN looks EmailAddress TimeOut HelpingBeing helped LateFee DabePublished Faculty_Borrow Staff Journals Reservation Code PK StaffilD Author Faculty D FK Films JobTitle ResoucelD FK ExecutiveProducer Volume Contact StaffID DatePublished FK ReleaseDate LastName Date FirstName LateFee TimeIN TimeOut Faculty FK FacultylD LastName FirstName EmailAddress

Solution

I have assumned that the late free can be some float value.

CREATE TABLE Student_Borrow(
Reservation_Code INT NOT NULL AUTO_INCREMENT,
StudentID INT,
ResourceID INT,
StaffID INT,
Date DATE,
TimeIN TIME,
TimeOut TIME,
LateFee FLOAT,
PRIMARY KEY (Reservation_Code),
FOREIGN KEY (StudentID) REFERENCES Student(StudentID),
FOREIGN KEY (ResourceID) REFERENCES Resources(ResourceID),
FOREIGN KEY (StaffID) REFERENCES Staff(StaffID)
);

CREATE TABLE Faculty_Borrow(
Reservation_Code INT NOT NULL AUTO_INCREMENT,
FacultyID INT,
ResourceID INT,
StaffID INT,
Date DATE,
TimeIN TIME,
TimeOut TIME,
LateFee FLOAT,
PRIMARY KEY (Reservation_Code),
FOREIGN KEY (FacultyID) REFERENCES Faculty(FacultyID),
FOREIGN KEY (ResourceID) REFERENCES Resources(ResourceID),
FOREIGN KEY (StaffID) REFERENCES Staff(StaffID)
);