Using er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd. You need to design a database to keep track of clubs at a high school. Attributes: A student may only join one club Some students do not join at all Club needs to have one student Need to capture students: Name Address Year of grad All Phone numbers Club name Club advisor Meeting dates
Using er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd.
You need to design a
Attributes:
A student may only join one club
Some students do not join at all
Club needs to have one student
Need to capture students:
Name
Address
Year of grad
All Phone numbers
Club name
Club advisor
Meeting dates
-> An ER diagram shows the relationship among entity sets.
-> In terms of DBMS, an entity is a table or attribute of a table in database.
-> So by showing relationship among tables and their various attributes, ER diagram shows the complete logical structure of a database.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
