Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality
Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Apply all 4 ERD rules. 1. Students may pledge a single house. A house may have many student's pledge. For each student we want their name, age, email, and phone. For the house, we want the house name, address, all amenities, and year the house was founded. (15 points) 2. A student can declare a single major. A major may have many students. We would like to know the students name and address. We would like to know the major name, and college name. ( 15 points) 3. A student may be part of many organizations and an organization may have many students. We want to capture the students name, address, age, and all email addresses. We want to know the organization name, address, and description. We also want to know the year and the semester a student is part of an organization. (20 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started