Consider the following entity relationship diagram (ERD). where two entities E1 and E2 have a relation R of cardinality 1: m.mE1E2The attributes of E1 are A11, A12 and A13 where A11 is the key attribute. The attributes of E2 are A21, A22 and A23 where A21 is the key attribute and A23 is a multi-valued attribute. Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements ofthe third normal form (3NF is designed from the above ERD. The number of tables in the database isR. Let E, and Ez be two entities in an E/R diagram with simple single-valued attributes. R, and R2 are two relationships between E, and Ez, where R, is one-to-many andR2 is many-to-many. R, and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relationalmodel?A 2B 3D 5Question 13Consider the entities 'hotel room', and 'person' with a many to many relationship 'lodging' as shown below:Hotel RoomLodgingPersonIf we wish to store information about the rent payment to be made by person (s)occupying different hotel rooms, then this information should appear as an attribute of

You have asked multiple questions so we will answer the first one for you. If you want any other…

Consider the following entity relationship diagram (ERD). where two entities E1 and E2 have a relation R of cardinality 1 m. m E1 R E2 The attributes of E1 are A11, A12 and A13 where A11 is the key attribute. The attributes of E2 are A21, A22 and A23 where A21 is the key attribute and A23 is a multi- valued attribute. Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

Consider the following entity relationship diagram (ERD). where two entities E1 and E2 have a relation R of cardinality 1 m. m E1 R E2 The attributes of E1 are A11, A12 and A13 where A11 is the key attribute. The attributes of E2 are A21, A22 and A23 where A21 is the key attribute and A23 is a multi- valued attribute. Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

3) A relation is said to be in 3NF if it is in 2NF and no nonprime attribute of R is blank the primary key. A) an alternate forB) transitively dependent on C) Part of D) partially functionally dependent onE) fully funcionally dependent on
HOMEWORK #6 Consider the following flawed ER diagram representing clubs and their activities. name club Sponsor date time building room activity capacity description A club has a unique ID and a name. An activity has a date, a time, and a description, and is in a room. A room has a unique (building, room number) and a capacity. Each activity is sponsored by exactly one club. 1. Following the rules we studied, convert the ER diagram into a relational schema. 2. The resulting schema is not in BCNF. Identify a non-trivial functional dependency where the left- hand side is not a superkey. 3. Decompose into schemas that are in BCNF. 4. Modify the ER diagram so that it corresponds to the normalized schema and briefly explain what the problem was with the original design.
DATABASE SYSTEM A relation R is given which is R(A,B,C,D,E). It has the following functional dependencies: BC -> ADE , D -> B. Answer the following based on this information. Which normal forms does this relation satisfy? Which type of dependencies does this relation violate? Normalize the relationship so that it decomposes to 3NF.
In order to be used as a primary key, which of these characteristics must an attribute possess with respect to a single instance of the entity? There must be a maximum of one attribute instance. There must be many instances of the attribute. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute. There must be zero or more instances of the attribute.
A well-structured database starts from an effective Entity Relationship Diagram (ERD). For this part of the question, you will need to sketch an ERD for the following gym scenario: A member must have a member ID, name and contact number, can be enrolled in one or more gym session. A gym session can be enrolled in by one or more members. Each gym session is identified by a session ID, and has a name, date and instructor details (Instructor ID). An instructor has an instructor ID, name and contact number, and must only be assigned to one gym session. A gym session can have one or more instructors assigned in it.” *show entities, relationship types and cardinalities. Crow’s foot model notations recommended.
b. Draw an Entity Relationship diagram from each of the following descriptions. Include the attributes, primary keys (underlines) and the relationships in the diagram (like relationship in Access). i. Each of the department has many employees assigned to it, but each employee works for only one department. if. A customer can rent many videotapes from the video store. Each of the videotapes can be rented to many customers.
Write a relation algebra based on the following algebra: Book (BookID, Price, Year, Author, Subject) BorrowLog (BID, BookID, CustomerID, DateTime) Customer (CustomerID, CustomerName, Address, City) 1. List all tuples from books which their subjects are database 2. List all tuples from books published after 2010 which their subjects are database and the prices are at least 450 3. List information about author and subject from the relation, Book
Translate the following ER Diagram into relational model. Show different relations that will result in addition to their attributes, PKs and FKs. Newspaper AK newsPaperID newsPaperName newsPaperAddress Work for Actor Joumalist AK actorID AK journalistID -interview- firstName journalistName lastName dateOFbirth nationality write Edition Article -publishedIN- AK editionID PK articlelD editionDate article Title related To Topic AK topicID topicWording
Question 2 Consider the following relation: Computer Repair(Comp ID, Engineer ID, Date Assigned, Customer_name, Customer_phone, Engineer_Name, Engineer_phone, Date_Repaired, Issue, Priority_Level, Service_Charge, Commission_Percentage, Total_Repairs) The primary key of the relation is underlined The relation has the following additional functional dependencies: FD1: Engineer_ID →→ Engineer_Name, Total_Repairs, Commission_Percentage, Engineer_phone FD2: Comp_ID, Date_Assigned → Issue, Priority_Level, Service_Charge FD3: Comp_ID Customer_name, Customer_phone FD4: Priority Level Service Charge FD5: Total Repairs Commission_Percentage i. Explain if this is in 1NF or not. If not, apply normalization to decompose it to 1NF. ii. Explain if this is in 2NF or not. If not, apply normalization to decompose it to 2NF. iii. Explain if this is in 3NF or not. If not, apply normalization to decompose it to 3NF
Given the database schema with the following relations: STUDENT (id_stud, name_stud) LECTURER (id_lect, name_lect) SUBJECT (id_subject, id_lect, name_subject, credits, id_room) ROOM (id_room, no_room) ENROLL (id_stud, id_subject) Create an algebraic relation for: a. Displays all names of lecturers who teach the subject with a total of 4 credits b. Displays all no_room with the student name "Eko" c. Displays all data in the form of student id, student name, name of the course followed and the name of the lecturer who taught the subject name "Database" From the database schema and the questions above, create an appropriate SQL query for each of these statements above.
a) Consider the given schema. Instructor(id, name, dept, address, age, phn_number) Student(s id, s_name, dept) If relationship set “Advisor" between the Instructor and Student entity sets. Explain the appropriate mapping cardinalities over this relation with appropriate figure. b) Consider the following set of functional dependency for the relation schema R = (A, B, C, D, E, F, M, N, P, R). • AB ---> E, F, M, N, P, R • A->C, D • B-> E, F, M, N • M->N Now normalize the given functional dependency up to 3NF.
You are given a relation R with the following attributes R(A,B,C,D,E). Assume that you were given the following functional dependencies: • FD1= AB -> E • FD2: = D -> C (a) What is a valid key for this relation? justify your response. (b) Is this relation in 3NF (Third Normal Form)? Justify your response. If it is not in 3NF, normalize the relation and demonstrate all steps of normalization.