A.) Map this ER diagram into a relational schema. B.) List all relations, and fo

Question

A.) Map this ER diagram into a relational schema.

B.) List all relations, and for each relation in your design, indicate: - The cardinality constraints (whenever applies, i.e. it should be a relationship) - Key constraints (PK) (whenever applies, i.e. it should be an entity) - Referential integrity constraints (FK) (whenever applies, i.e. it should be an entity)

Date Time stamp Time SHIP MOVEMENT Longitude Latitude HISTORY Tonnage Hull SHIP SHIP TYPE Start dateEnd HOME PORT SHIP AT PORT PORT VISIT nt (0%) IN STATE/COUNTRY Name PORT ON SEA/OCEAN/LAKE

Explanation / Answer

SHIP(Sname(PK),Owner,SHIP_AT_PORT(FK OF PORT PNAME),HOME_PORT(FK OF PORT PNAME),TYPE(FK SHIP_TYPE(TYPE)),TIME_STAMP(FK SHIP_MOVEMENT(TIME_STAMP)))
SHIP_MOVEMENT(TIME_STAMP,LONGITUDE,LATITUDE)
SHIP_TYPE(TYPE(PK),TONNAGE,HULL)
PORT_VISIT(START_DATE,END_DATE,SNAME(FK SHIP(SNAME)) ,PNAME(FK PORT()PNAME))
PORT(PNAME(PK),START_DATE,END_DATE)
STATE/COUNTRY(NAME(PK),CONTINENT,PNAME(FK OF PORT))
SEA/OCEAN/LAKE(NAME(PK),PNAME(FK OF PORT))

SHIP ------1 TO MANY-----> SHIP_MOVEMENT.
SHIP -------MANY TO 1-----> SHIP_TYPE.
SHIP -------MANY TO 1-----> PORT.
SHIP -------MANY TO MANY------>PORT_VISIT.
PORT -------MANY TO 1 ----->STATE/COUNTRY.
PORT -------MANY TO 1 ----->SEA/OCEAN/LAKE.
PORT -------MANY TO MANY ----->PORT_VISIT.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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