I need This Assignment Completed by tomorrow.

1 answer below »
Answered 1 days AfterJan 31, 2023

Answer To: I need This Assignment Completed by tomorrow.

Sathishkumar answered on Feb 02 2023
34 Votes
Question 1: ER-EER
1)Identification of Entities- attributes
    Entity
    Attributes
    Relationship
    Patient
    Patient ID
Name
Address
Teleph
one number
    Arrives
    Ward
    Ward Type
Ward Identifier
Ward Location
Nurse ID
Doctor ID
    Admitted
    Employee
    Name
Insurance ID
Gender
DOB
Salary
Address
    Manages
2) ER-EER diagram
Question 2:
Question 3: Identification of Foreign Keys
    Entity
    Foreign Keys
    Student
    Studsin
Name
Major
Bdate
    Department
    DeptName
Location
    Course
    Course Name
Credit Hr
Dept No
    Text
    Book Title
Publisher
Author
    Section
    Emp No
    Perquisite
    -
    Enroll
    Grade
    Book-Adoption
    Book ISBN
    Instructor
    EmpSin
Name
Dept No
2)Relational Database
Question 4:
a) Recursive relationship: Whenever two things share a common type, we call their relationship a recursive one. This shows that the two entities involved in the relationship are instances of the same type. Some examples of relationships with a provable recursive structure are as follows. One worker can oversee multiple subordinates.
b) Weak Entity: A weak entity is an entity that cannot be uniquely recognized by using only its attributes within a relational database. As a result, in order to generate a primary key for the entity, a foreign key must be used in conjunction with its attributes. In most cases, the primary key of the entity that the foreign key is associated to serves as that entity's primary...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here