Consider the following relation named Trip. The functional dependencies are as follows: TripID, SeasonNum → Trip (TripID, TripName, StartLocation, State, Distance, MaxGipSize, Type, SeasonNum, Season TripID → SeasonNum Season A. B. The tables that are in third normal form are: C. [TripName, StartLocation, State, Distance, MaxGrpSize, Type (TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season] Trip (TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (SeasonNum, Season), TripSeason (TripID, SeasonNum) Trip (TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (SeasonNum, Season) Trip TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (TripID, SeasonNum, Season) D. None of the above

Consider the following relation named Trip. The functional dependencies are as follows: TripID, SeasonNum → Trip (TripID, TripName, StartLocation, State, Distance, MaxGipSize, Type, SeasonNum, Season TripID → SeasonNum Season A. B. The tables that are in third normal form are: C. [TripName, StartLocation, State, Distance, MaxGrpSize, Type (TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season] Trip (TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (SeasonNum, Season), TripSeason (TripID, SeasonNum) Trip (TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (SeasonNum, Season) Trip TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (TripID, SeasonNum, Season) D. None of the above

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

under what three circumstances does it become necessary to generate a surrogate key in place of the main key of a relation?
19. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation . a. Referential relation b. Referencing relation c. Referenced relation d. Referred relation
Lab 3: Normalization Assignment: Problem #11 from Chapter #6. (Be sure to note that this is PROBLEM and not REVIEW QUESTION). Normalize a set of data to 1st, 2nd and 3rd normal form by creating relational schemas, dependency diagrams and an Entity Relationship Diagram (crow’s foot notation). For this lab, complete problem #11 in Chapter 6. Be sure to complete each letter (a thru c) for the problem. The ERD for letter cmust be completed with the use of Microsoft Visio. Remember to include headers on all documents you submit to include a brief descriptive title, your name and a date. Question 11: Given the sample records in the CHARTER table shown in Table P6.11, do the following: Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies. CHAR_PAX indicates the number of passengers carried. The CHAR_MILES entry is based on round-trip miles, including pickup points. (Hint: Look at the data values to determine the…
47. Answer items a, b, and c below based on the following relation and dependencies. T_Participation(StudentID, ActivitylD, SFirstName, SLastName, ADescription, Date, RoomlD, Cost) PFD: StudentID SFirstName, SLastName PFD: ActivitylD ADescription, RoomlD FD: StudentID, ActivitylD → Date FD: RoomlD → Cost a. What normal form is this currently in? b. Why is it in that form (and not another)? c. Do whatever is necessary to bring it into 3NF (if not already there).
What does it mean to be related? How do you define a relation's properties?
What is an unnormalized relation? Is it a relation according to the definition of the word relation?
Normalise the following relation to remove modification anomalies showing all steps for 1NF, 2NF and 3NF . State any necessary assumptions to support your answer. Important : Provide appropriate justification for each normalisation step. STUDENTCOURSE(StudentNumber, StudentName, TotalCredits, GPA, AdvisorNumber, AdvisorName, Office, CourseNumber, CreditHours, Grade) Primary Key: StudentNumber, CourseNumber Functional DependenciesStudentNumber -> StudentName, TotalCredits, GPA, AdvisorNumber, AdvisorName, OfficeAdvisorNumber -> AdvisorName, OfficeCourseNumber -> CreditHoursStudentNumber, CourseNumber -> Grade
Q9
2. For the following questions, please identify the candidate keys of the given relations. You need to show the process to justify your answers. a) The given relation is R1(ABCDE). The given dependencies are A B B-E C-D b) The given relation is R2(ABCDE). The given dependencies are AB→BCDE BC ACE D-E
a. Provide the relation (relational notation) that represents the user view for the school advising system.b. Transform the user view into the third normal form. Show the intermediate steps in the normalization process, i.e. 1NF, 2NF, 3NF.
For the table BOOKAUTHOR below you are given the following functional dependencies. BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition) Functional dependencies: 1. ISBN BookTitle, Publisher, Edition 2. Author Num → LastName 3. BookTitle → Publisher 4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition Write the types of functional dependencies shown in (1) to (4) above. Also, decompose the table to the third normal from (3NF).
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.