1. Create an Entity Attribute Relationship (EAR) Diagram and Relational Schema using app.diagrams.net export as PDF...

Transcribed Image Text:

1. Create an Entity Attribute Relationship (EAR) Diagram and Relational Schema using app.diagrams.net export as PDF 2. Create Data Dictionary for the Faculty/CourseSection ERD using Student Registration Dictionary Example.xls as a template. Please examine the following scenario - Business: School This school has courses and faculty to track. They need you to define a subset of a larger DBMS that allows the faculty members to be assigned to a course sections. A faculty member can teach several courses but a course can have only one faculty member assigned. The course information consists of: (Attribute names are in Bold) CourseSection Identification Number (CID - Number(6)} - Unique for each section of a course . Department Number {Dept - Numeric(2)} • Course {Crs - Numeric(3)} Section {Sect - Numeric(3)} • Credit Hours - (CrHrs - Numeric (3,2)} • Title {Text(50)} • Seats (Numeric(3)} Mentine Time (MAdaT Taocd7E) CourseSection Identification Number {CID - Number(6)} - Unique for each section of a course . Department Number {Dept - Numeric(2)} • Course {Crs - Numeric(3)} Section {Sect - Numeric(3)} • Credit Hours - {CrHrs - Numeric (3,2)} • Title (Text(50)} • Seats {Numeric(3)} • Meeting Time (MtgTime - Text(75)} The Faculty information consists of: Faculty Identification Number {FID-Number(6)} - Unique for each faculty member Name (Text(100)} • Primary Department {PriDept - Number(2)} • Address {Text(100)} Primary Phone {Phone - Text(10)} Seniority Level {Seniority - Number(2)} You are to create an Entity-Attribute-Relationship Diagram to represent the conceptual model of a database that could connect the transactions in this scenario. 10/6/2023 TABLE NAME Student Registration Course SID Name Address Phone GPA ATTRUBUTE NAME ATTRIBUTE DESCRIPTION SID CID RegistrationDate TABLE DESCRIPTION Contains personal information about students Contains the course/student registration information Contains the information related to the course STUDENT TABLE CID SubjCrs Title Crirs Dept ATTRUBUTE NAME ATTRIBUTE DESCRIPTION System Generated unique number used to identify students Students full Name (Last, First, MI.) Full Street Address Primary Phone Number Grade Point Average REGISTRATION TABLE Student Identification Number Course Identification Number Data Dictionary Example Student Registration System # of Attributes COURSE TABLE ATTRUBUTE NAME ATTRIBUTE DESCRIPTION Number Number The date of the registration. The date the record was added to th DATE System Generated unique number used to identify courses Subject Abbreviation and course number The Title of the course The assigned course credit hours The Department of the course. varChar (10) Number Type Type ALL Number varChar(75) ALL varChar(100) ALL 5 3 Type 5 Domain ALL 0.00-4.00 Domain ALL ALL ALL Domain Number ALL varChar(10) ALL varChar(100) ALL Number varChar(50) ALL 0.0-6.0 PK FK Null Yes No No No No No No No No No No No No No No PK FK Null Yes Yes No Yes Yes No No No No PK FK Null Yes No No No No No No No No No No No No No No 1. Create an Entity Attribute Relationship (EAR) Diagram and Relational Schema using app.diagrams.net export as PDF 2. Create Data Dictionary for the Faculty/CourseSection ERD using Student Registration Dictionary Example.xls as a template. Please examine the following scenario - Business: School This school has courses and faculty to track. They need you to define a subset of a larger DBMS that allows the faculty members to be assigned to a course sections. A faculty member can teach several courses but a course can have only one faculty member assigned. The course information consists of: (Attribute names are in Bold) CourseSection Identification Number (CID - Number(6)} - Unique for each section of a course . Department Number {Dept - Numeric(2)} • Course {Crs - Numeric(3)} Section {Sect - Numeric(3)} • Credit Hours - (CrHrs - Numeric (3,2)} • Title {Text(50)} • Seats (Numeric(3)} Mentine Time (MAdaT Taocd7E) CourseSection Identification Number {CID - Number(6)} - Unique for each section of a course . Department Number {Dept - Numeric(2)} • Course {Crs - Numeric(3)} Section {Sect - Numeric(3)} • Credit Hours - {CrHrs - Numeric (3,2)} • Title (Text(50)} • Seats {Numeric(3)} • Meeting Time (MtgTime - Text(75)} The Faculty information consists of: Faculty Identification Number {FID-Number(6)} - Unique for each faculty member Name (Text(100)} • Primary Department {PriDept - Number(2)} • Address {Text(100)} Primary Phone {Phone - Text(10)} Seniority Level {Seniority - Number(2)} You are to create an Entity-Attribute-Relationship Diagram to represent the conceptual model of a database that could connect the transactions in this scenario. 10/6/2023 TABLE NAME Student Registration Course SID Name Address Phone GPA ATTRUBUTE NAME ATTRIBUTE DESCRIPTION SID CID RegistrationDate TABLE DESCRIPTION Contains personal information about students Contains the course/student registration information Contains the information related to the course STUDENT TABLE CID SubjCrs Title Crirs Dept ATTRUBUTE NAME ATTRIBUTE DESCRIPTION System Generated unique number used to identify students Students full Name (Last, First, MI.) Full Street Address Primary Phone Number Grade Point Average REGISTRATION TABLE Student Identification Number Course Identification Number Data Dictionary Example Student Registration System # of Attributes COURSE TABLE ATTRUBUTE NAME ATTRIBUTE DESCRIPTION Number Number The date of the registration. The date the record was added to th DATE System Generated unique number used to identify courses Subject Abbreviation and course number The Title of the course The assigned course credit hours The Department of the course. varChar (10) Number Type Type ALL Number varChar(75) ALL varChar(100) ALL 5 3 Type 5 Domain ALL 0.00-4.00 Domain ALL ALL ALL Domain Number ALL varChar(10) ALL varChar(100) ALL Number varChar(50) ALL 0.0-6.0 PK FK Null Yes No No No No No No No No No No No No No No PK FK Null Yes Yes No Yes Yes No No No No PK FK Null Yes No No No No No No No No No No No No No No

Answer rating: 100% (QA)

Introduction EAR Diagram An EntityRelationship ER diagram is a graphical representation used in data... View the full answer