I need This Assignment Completed by tomorrow.

Question

Sathishkumar · Accepted Answer

Question 1: ER-EER 
1)Identification of Entities- attributes
	Entity
	Attributes
	Relationship
	Patient
	Patient ID
Name
Address
Telephone 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,

I need This Assignment Completed by tomorrow.

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment