Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the ERD of a school database in Figure 8 . 1 5 to answer questions 6 to 9 . 6 . Identity all the
Use the ERD of a school database in Figure to answer questions to
Identity all the kernels and dependent and characteristic entities in the ERD.
Kernel: From the table above the kernels are the table which has no foreign keyie
The table with no foreign key are Instructor, Course, Student and Offering.
Characteristics: Attendance is considered as Characteristic entities as it consists of student ID which gives information about student table.
Which of the tables contribute to weak relationships? Strong relationships?
Here attendance is the weak entity or table which has weak relationships. Instructors and Instructor have a strong relationship.
Looking at each of the tables in the school database in Figure which attribute could have a NULL value? Why?
Here in student table fax no can be null because they do not have fax no again a student may or may not have passport program, so this attribute can be null, companyid can also have null. In instructor table mentorid can be null because instructor may or may not be a mentor.
Which of the tables were created because of too many relationships?
Onetomany: This relationship allows a single row at one table to be linked with multiple rows in another table. A common example is a customer who can place multiple orders, where each order is linked back to one customer.
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