Hello again, Just want to check my answers. I have created a Logical Model with

Question

Hello again,

Just want to check my answers.

I have created a Logical Model with the following 8 entities. I wanted to see if I have correctly labelled the folloiwng:

1. 8 Entities

2. Attributes

3. Suitable Data Type

Thank you

Nurse EnployeeID INTEGER P EmployeeID 1 INTEGER LastName TEXT FirstName TEXT Hospita1Name TEXT UnitName TEXT spitalName TEXT PK HospitalName 1 TEXT TEXT TEXT INTEGER Doctor OfficeLocation NPINumber 1 INTEGER LastName TEXT FirstName Text Degree Speciality TEXT TEXT Hospital PatientID INTEGER PK HospitalName TEXT PK Hospita1Name TEXT LastName TEXT FirstName TEXT RoomNumber INTEGER NPINumber INTEGER HospitalName 1 TEXT MainAddress TEXT DoctorPatient NPINumber PatientID INTEGER PK PatientID 1 Appointment INTEGER INTEGER DATETIME RoomNumber+HospitalName INTEGER PK HospitalName TEXT PK PatientID HospitalName_1 RoomNumber 1 INTEGER TEXT INTEGER NursePatient EmployeeID+PatientID INTEGER PK EmployeeID 1 PatientID 1 UnitName INTEGER INTEGER TEXT

Explanation / Answer

NURSE

employee id =integer

last name,first name, hospital name, unit name= varchar

in all your program, use VARCHAR instead of TEXT.

and your logical model is correct.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.