Question

CSCI 3700 - Introduction to MIS Assignment 4-Entity Relationship Diagram Entity relationship diagrams document the relationships between entities in a database environment. The following is an example from the textbook (p 254) Address Name Email Ships Hem Orders Price Forwards Credit Card Creates Order Number Entity Relationship Attribute :0ne 0-Zero or more. Optional )-=Many In the above example, we can identify the entities (what would be tables within our database), the attributes (the items that describe the entity), the relationship (how are entities connected), and the cardinality (how many instances can exist in the relationship).

Answer 1

there are 7 entitie

student

classroom

course

department

major

college

Faculty

and below are the relation between them

1) student enrolls for Course ( and there is may to one relationship since many student can enrolls for one course)

2) students elects major (and there is 1 to 1 relationship since student can elect only 1 major)

3) course is studied at classroom (1to1 relationship since 1 couse is studied at a single classroom)

4) faculty teaches course ( many to many since many faculty can teaches the course)

5) faculty belongs to college (one to one since since one faculty can belongs to only one college)

6)faculty belongs to department

ER diagram screenshot

PloSS eom Dept oss Room Dur