Answered step by step
Verified Expert Solution
Link Copied!

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 -

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions

Question

4. I can tell when team members dont mean what they say.

Answered: 1 week ago