Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

1. Create an Entity Attribute Relationship (EAR) Diagram and Relational Schema using app.diagrams.net exportCourseSection Identification Number {CID-Number(6)} - Unique for each section of a course  Department Number10/6/2023 TABLE NAME Student Registration Course SID Name Address Phone GPA ATTRUBUTE NAME ATTRIBUTE

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

Step by Step Solution

3.58 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

Introduction EAR Diagram An EntityRelationship ER diagram is a graphical representation used in data... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Programming questions

Question

Why do some employees work well in teams and others do not?

Answered: 1 week ago

Question

=+a) Write the null and alternative hypotheses.

Answered: 1 week ago

Question

What is self-training?

Answered: 1 week ago