Answered step by step
Verified Expert Solution
Question
1 Approved Answer
draw an estimated complete ER DIAGRAM. 1. CREATE TABLE Department (Department_id varchar(w), Department Name varchar(30)); 2. CREATE TABLE Facility (fucility - Id varchar(10), facility -
draw an estimated complete ER DIAGRAM.
1. CREATE TABLE Department (Department_id varchar(w), Department Name varchar(30)); 2. CREATE TABLE Facility (fucility - Id varchar(10), facility - No -Mame varchar (20), Department_id varchar(10) REFERENCES Department (Department_id)); 3. CREATE TABLE Student (student_id varchar Cio) primany tey, student_ Name varchar (30), Student Address varchar (30), Varchar (15) UNIQE, sex char(1)); Student Phone no 4. CREATE TABLE Staff (Staff_id varchar (10) primary tey, Stuff_N f Name varchar (o) staff - Address varchar (30), Staff Phoneno varchar (15) UNIQUE, Department.Id varchar PEFERENCES Department Department 10) Sex char(1)); 5. CREATE TABLE Smart Card (Smartcard-ld varchar (10) primary key, Student_id varchar (10) REFERENCES Student (stuckent_id), Staffuld varchar (10) REFERENCES Staff (staff.id), expiry-date SMALL DATETIME); 6. CREATE TABLE Booking CBooting-Id varchar (10) primary tey, Student Hot terchor Smartcarel-Id varchar(10) Smartcard (smartcarel_id), facility varchar Co) REFERENCES facility fucking hop REFERENCES 1. CREATE TABLE Biometric (siometric-Id varchar (io) primary tey, Smartcard-id varchar(10) REFERENCES Smartcarl (Smertcards)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started