![EBK CONCEPTS OF DATABASE MANAGEMENT](https://www.bartleby.com/isbn_cover_images/8220100706004/8220100706004_largeCoverImage.jpg)
(a)
To find the relationship between students, courses and faculty members in the specified relation.
(a)
![Check Mark](/static/check-mark.png)
Explanation of Solution
The given relation is
The above relation Student and Faculty has many-to-many relationship since a new table is generated whose primary key is the combination of all primary key.
Since a faculty teaches many students and a student is taught by many faculties. Therefore, the relation between student and faculty is many-to-many relationship.
The relation between Student and Course has many to many relationships since a student can take many courses and a course can be taken by many students.
After creating new table, the collection of tables is as follows:
(b)
To find the relationship between students, courses and faculty members in the specified relation.
(b)
![Check Mark](/static/check-mark.png)
Explanation of Solution
The given relation is as follows:
Since one student can take many courses and one course is taken by many students.
Therefore, the attributes StudentNum and CourseNum in the Student relation used as the primary key shows the many-to-many relationship between StudentFaculty and Course tables.
The relation Faculty and Course has many-to-many relationship since one faculty can be assigned many course numbers and one course number can be assigned to many faculties.
After creating new table, the collection of tables is as follows:
(c)
To find the relationship between students, courses and faculty members in the specified relation.
(c)
![Check Mark](/static/check-mark.png)
Explanation of Solution
The given relation is as follows:
The relation StudentFaculty and Faculty has many-to-many relationship since many students have assigned many courses.
The relation Faculty and Course has many-to-many relationship as many faculties can be assigned many courses.
The relation StudentFaculty and Course has many-to-many relationship since one faculty can be assigned many course numbers and one course number can be assigned to many faculties.
Also, the relation StudentFaculty and Faculty has many to many relationships since one student is taught by many faculties and one faculty can be assigned to many students.
(d)
To find the relationship between students, courses and faculty members in the specified relation.
(d)
![Check Mark](/static/check-mark.png)
Explanation of Solution
The given relation is
The above relation Student and Faculty has many-to-many relationship since a new table is generated whose primary key is the combination of all primary key.
Since a faculty teaches many students and a student is taught by many faculties. Therefore, the relation between student and faculty is many-to-many relationship.
The relation between Student and Course has many tomany relationships since a student can take many courses and a course can be taken by many students.
After creating new table the collection of tables are as follows:
(e)
To find the relationship between students, courses and faculty members in the specified relation.
(e)
![Check Mark](/static/check-mark.png)
Explanation of Solution
The given relation is as follows:
The relation Student and Course has many-to-many relationship since many students have assigned many courses.
The relation Faculty and Course has many-to-many relationship since many faculties can be assigned to many subjects.
The relation Student and Faculty has many-to-many relationship since one faculty can be assigned many students and one student can be assigned to many faculties.
Want to see more full solutions like this?
Chapter 6 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
- Which of the following statements corresponds to the second normal form for an entity - relationship model in relational databases? A relationship must have only one key and the attributes můst have simple donains B A relationship must have a Kev, with simple domains for its attributes and all non-key attributes depend entirely on the key A relationship must have a key with static domains for its attributes which all depend on the key A relationship must have only one key with all attributes dependent on the key. A. Darrow_forwardWhat is the degree of a relationship? Give anexample of each of the relationship degreesillustrated herein.arrow_forwardConvert the Entity Relationship Diagram in to relational database by using MS Access (Note: Students has to create tables in the MS Access by giving appropriate Primary key and Foreign key relationships) QI. Customer Order OrderDetail CustomeriD OrderiD OrderiD (FK) OrderDetaillD Name Mail ZipCode Address Telephone CustomeriD (FK) OrderDate TotalPrice ProductiD (FK) Amount Price Product ProductiD Name Kind Pricearrow_forward
- Explain how functional dependencies can be used to indicate the following: • A one-to-one relationship set exists between entity sets student and instructor. • A many-to-one relationship set exists between entity setsstudent and instructor.arrow_forwardWhat is the degree of relationship?Give an example of a relationship of degree threearrow_forwardCreate an unnormalized relation using student and class entities.arrow_forward
- Explain how functional dependencies may be used to indicate: • The entity sets student and teacher have a one-to-one relationship set.• Between entity setsstudent and teacher, there is a many-to-one connection set.arrow_forwardCreate Relation Schema for ERD in question 1(question 1 was: Create ERD for the given case study using Crows Feet Notation)arrow_forwardQ3: Define a relation prereq depth(course id, prereq id, depth) where the attribute depth indicates how many levels of intermediate prerequisites there are between the course and the prerequisite. Direct prerequisites have a depth of 0. Note that a prerequisite course may have multiple depths and thus may appear more than once.arrow_forward
- Consider the following relations database schema. The primary key is underlined, and all attributes are of type string if not indicated otherwise. branch(branch_name, branch_city) customer(customer_id, customer_name,customer_street,customer_city) account(account_number, branch_name, balance: integer) depositor(customer_id, account_number) Write SQL queries to: Find all the branch names with customers who have accounts of balance less than $2000 and the branch is located in LA. Delete all customers who do not have an account. (Assume the bank keeps the customer information even if the account is closed.arrow_forwardQuestion: Consider a relation named as BOOK that contains data about the books in a library. BOOK relation was initially created with the attributes BookID (an id that library assigns), ISBN, CopyNr (used to differentiate copies of the same book), Title, PublYear, Author, and AuthorBornYear. Primary key: BookID, CopyNr and Author Candidate key: ISBN, CopyNr and Author Below you see dependencies of attributes: Dependency 1 (D1): ISBN, Title, PublYear, AuthorBornYear were dependent on BookID, CopyNr, and Author Dependency 2 (D2): Title and PublYear were dependent on BookID, CopyNr Dependency 3 (D3): AuthorBornYear was dependent on Author First determine which normal form (1NF, 2NF, 3NF, or BCNF) the above relation is, and why. Then, if necessary, convert the above relation to the highest normal form (BCNF). Write any assumptions that you make Subject: MYSQLarrow_forwardWhat is the connection between the primary key of a relation and the functional relationships that exist between all of its attributes?arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)