Question

Part I. Mapping an (E)ER schema to a relational database schema (46 points) NOTE o Each relation sachem should have a primary key (PK) when you answer. • To present the reference table of the foreign key (e.g., FK, FK1, K2), use an arrow. Do not use the relationship cardinality symbols of crow's foot notation in the relational database schema. o It is not required to specify the domain constraint (e.g., data type and length) of each attribute. 1. (12 points) Transform each fragment of an ER diagram into a relational schema(s) Class Class author) C title publisher (room isbn Textbook room schedule classNumber deptCode / section courseNumber publication year 1.1 facldrank name name Faculty Faculty IsRated Student office Cohone numbers stuld name date. date Evaluation Evaluation area code line number _rater rating

Answer 1

Answc1. dalabase mapping an (ECER schema to do a relational chema a relationa! Schema class room depl code couise Numbry section schedule var chao varchao . INT varchar(o ] DATE 2 ſext book ": 60 Publication year | Published 1 title ben INT INT varchar(s) varchar (so) is bhum author Scanned VINT CamScanner var char (0)

- Faculty Fac 20 rant name office INT INT varchal varchar (50) Evalution fid date I rater Yo be ŏ + INT DATE DATE 2 stodent Phone . for stugd name sid area code I Line rumba INT varchar(su) INT varchan (10) vard (90) Scanned with CamScanner