1. Given the followving relation that stores details about students' activities:ActivityFee AmountPaid65.00StudentID StudentNameActivityGolf100Jones65.00100JonesSkiingSkiing200.000.00200Davis200.000.00200DavisSwimmingSkiingSwimming 50.0050.0050.00300Garrett200.00100.00300Garrett50.00400JonesGolf65.0065.00400Swimming 50.00Jones50.00If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE.StudentID → StudentNameStudentID , StudentName → ActivityActivity > ActivityFeeActivity → StudentIDStudentID → ActivityStudentID → AmountPaid||

here have to determine functional dependencies with given relation.

1. Given the following relation that stores details about students' activities: StudentID StudentName ActivityFee AmountPaid Activity Golf 100 Jones 65.00 65.00 Skiing Skiing Swimming 50.00 100 Jones 200.00 0.00 200 Davis 200.00 0.00 200 Davis 50.00 300 Garrett Skiing Swimming 50.00 Golf 200.00 100.00 300 Garrett 50.00 400 Jones 65.00 65.00 Jones Swimming 50.00 400 50.00 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. StudentID → StudentName StudentID , StudentName → Activity Activity → ActivityFee Activity → StudentID StudentID → Activity| StudentID → AmountPaid 888333

1. Given the following relation that stores details about students' activities: StudentID StudentName ActivityFee AmountPaid Activity Golf 100 Jones 65.00 65.00 Skiing Skiing Swimming 50.00 100 Jones 200.00 0.00 200 Davis 200.00 0.00 200 Davis 50.00 300 Garrett Skiing Swimming 50.00 Golf 200.00 100.00 300 Garrett 50.00 400 Jones 65.00 65.00 Jones Swimming 50.00 400 50.00 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. StudentID → StudentName StudentID , StudentName → Activity Activity → ActivityFee Activity → StudentID StudentID → Activity| StudentID → AmountPaid 888333

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Draw the relationships and entities model for each of the following: * in the traditional way* for example: see the pic??. In the database of the library, the author can author more than one book, and the book can be subscribed toWritten by more than one author
Given the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salim Housni 2000 200-B Salim Housni 2000 200-C Salim Housni 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE ProjectID --> EmployeeName (....) ProjectID --> EmployeeSalary (....) ProjectID , EmployeeName -->EmployeeSalary (....) EmployeeName --> EmployeeSalary (....) EmployeeSalary --> ProjectID (....) EmployeeSalary --> EmployeeName , ProjectID (....)
We have a relation with the following attributes: R={A,B,C,D,E} and all the attributes are atomic. Primary key of this relation is AB. What is the normal form of this relation given the following functional dependencies: AC→D, AB→C, AB→D, AB→E Select one: a. First Normal Form b. This relation is not normal. c. Third Normal Form d. Second Normal Form
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.
Consider the following relations: Employee(E_id: integer, E_name: string, Age: integer, Salary: real) Works(E_id: integer, Dep_id: integer, Start_date: date) Department(Dep_id: integer, Dep_name: string, Budget: real, Manager_E_id: integer) What referential integrity constraints exist between these relations? What are the options for enforcing these constraints when a user attempts to delete a Dept tuple?
Let's break down the information into entities, attributes, and relationships: Entities: 1. Ship - ShipID (Primary Key) - ShipName - ShipType 2. Captain - CaptainID (Primary Key) - CaptainName - CaptainLicense 3. ShipmentTrip - TripID (Primary Key) - DeparturePort - ArrivalPort - RouteDetails 4. ShipmentManifest - ManifestID (Primary Key) - Date - GoodsList 5. Goods - GoodsID (Primary Key) - GoodsName - GoodsType (BM or LM) 6. Port - PortID (Primary Key) - Street - City - State - PostalCode - Country Relationships: - Ship to ShipmentTrip (Many-to-Many): - Ship can participate in multiple ShipmentTrips, and a ShipmentTrip can involve multiple Ships. Create a junction table `Ship_ShipmentTrip` with attributes `ShipID` and `TripID`. - Captain to ShipmentTrip (Many-to-Many): - A Captain can be assigned to multiple ShipmentTrips, and a ShipmentTrip can have multiple Captains. Create a junction table `Captain_ShipmentTrip` with attributes `CaptainID` and `TripID`. - Captain to Ship…
Task Description: consider the following relations for a university: Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, develop and execute the following queries: 1- For each student with GPA between 2.5 (included) and 3.5 (included), display the student’s name, GPA,and his/her department ID. Sort the results by the students’ IDs in descending order. 2- For each student who joined the Computer Science department between 2018…
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 is three 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.
Suppose relations R(A,B) and S(B,C,D) are as follows
I need help with the following Consider a STUDENT relation in a UNIVERSITY database with the followingattributes (Name, Ssn, Local_phone, Address, Cell_phone, Age, Gpa). Note thatthe cell phone may be from a different city and state (or province) from thelocal phone. A possible tuple of the relation is shown below:Name Ssn Local_phone Address Cell_phone Age GpaGeorge Shaw 123-45-6789 555-1234 123 Main St., 555-4321 19 3.75William Edwards Anytown, CA 94539a. Identify the critical missing information from the Local_phone andCell_phone attributes. (Hint: How do you call someone who lives in a dif ferent state or province?)b. Would you store this additional information in the Local_phone andCell_phone attributes or add new attributes to the schema for STUDENT?c. Consider the Name attribute. What are the advantages and disadvantagesof splitting this field from one attribute into three attributes (first name,middle name, and last name)?d. What general guideline would you recommend for…
Let relations r1(A, B, C) and r2(C, D, E) have the following properties: r1 has20,000 tuples, r2 has 45,000 tuples, 25 tuples of r1 fit on one block, and 30tuples of r2 fit on one block. Estimate the number of block transfers and seeksrequired using each of the following join strategies for r1 ⋈ r2: Block nested-loop join.
DATABASE SYSTEMS 16.Consider a relation R = (A,B,C,D,E) with the following functional dependencies: {C,E → D, D → B, C → A} and identify a candidate key. None of them {C,E,D} {C,E,B} {C,E} 17.A join in which tuples from R1 that do not have matching values in the common attributes of R2 are also included in the result relation. R1 left outer join R2 R1 semi join R R1 equi join R2 R1 natural join R2 18.When two transactions that access the same database items have their operations interleaved in a way that makes the values of some database items incorrect this problem is call? none of them dirty read summary problem the lost update problem 19.Protect the database from inconsistencies and data loss Database recovery Database Transaction & Concurrency control Concurrency control Concurrency control & Database recovery 20.Let E1 and E2 be two entity types in an entity relationship diagram. E1 have all three simple single-valued attributes while E2 have two simple…

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning