b. Indicate for each of the following potential functional dependencies, whether it is indeed a functional dependence or NOT.1. NUMBER → TITLE2. STARTPAGE → ENDPAGE3. NUMBER → (STARTPAGE, ENDPAGE, PUBLICATIONS, VOLUME)4. TECHNICAL_REPORT_ID → NUMBER5. (PUBLICATION, VOLUME) → YEAR 6. TITLE → NUMBER Consider the following relation:ARTICLES (NUMBER, TITLE, PUBLICATION, VOLUME, YEAR, STARTPAGE, ENDPAGE,TECHNICAL_REPORT_ID)The relation contains information on articles published in publications (Journals). Each articlehas a unique number, title, and information on where to find it (name of the publication, whatvolume, and on which pages is appearing), also the ID of the technical report is specified.The following is an illustration of the relation:NUMBERTITLEPUBLICATION| VOLUMEYEARSTARTPAGE ENDPAGETECHNICAL_REPORT_ID240Junior PC gamesSAJS15201914115387330Early ChildwoodSAJS142016799526330Early ChildwoodSAJS142016799565930Data DictionarySAJEMS13201621123374750SACJP_value vsEquilibriam1520201.499solved770Data missedSAJEMS1520201.6.89870Data missedNature33332020333389

Answer: 1. Its a functional dependency 2. Not a functional dependency

b. Indicate for each of the following potential functional dependencies, whether it is indeed a functional dependence or NOT. 1. NUMBER → TITLE 2. STARTPAGE → ENDPAGE 3. NUMBER → (STARTPAGE, ENDPAGE, PUBLICATIONS, VOLUME) 4. TECHNICAL_REPORT_ID → NUMBER 5. (PUBLICATION, VOLUME) → YEAR 6. TITLE → NUMBER

b. Indicate for each of the following potential functional dependencies, whether it is indeed a functional dependence or NOT. 1. NUMBER → TITLE 2. STARTPAGE → ENDPAGE 3. NUMBER → (STARTPAGE, ENDPAGE, PUBLICATIONS, VOLUME) 4. TECHNICAL_REPORT_ID → NUMBER 5. (PUBLICATION, VOLUME) → YEAR 6. TITLE → NUMBER

CMPTR

3rd Edition

ISBN:9781337681872

Author:PINARD

Publisher:PINARD

Chapter17: Creating A Database

Section: Chapter Questions

Problem 4QY

See similar textbooks

Similar questions

rrttty
Please convert this eerd to relation. Thanks!!
Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
Any relation must have at least ONE Select one: a. Foreign Key b. Composite key c. Alternate key d. Candidate key
Each publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERD
Material : Relational Algebra Course : Database Systems Create a Relational Algebra From Entity Relational Diagram (ERD) Below for:a) Displays books published in the last 5 years from 2020.b) Displays details of customers who have done shopping (using the Join operator)c) Displays email customers who have done shopping (using the Set operator)d) Displays the ISBN book that has never been purchased (using the Set operator)
The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) for CONTAINS nad PRESCRIBED table , which one is primary key and how to create table ?
a) Put the following relation in BCNF: STUDENT_ACTIVITY STUDENT_ACTIVITY (StudentID, StudentName, Activity, ActivityFee, AmountPaid) StudentID StudentName Activity ActivityFee AmountPaid 1 100 Jones Golf 65.00 65.00 2 100 Jones Skiing 200.00 0.00 3 200 Davis Skiing 200.00 0.00 4 200 Davis Swimming 50.00 50.00 5 300 Garret Skiing 200.00 100.00 6 300 Garrett Swimming 50.00 50.00 7 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00 b) Put the following relation in BCNF: Student(SSN, sName, address, HScode, HSname, HScity,GPA, priority) Assuming a student can attend more than one high school, and priority is determined by GPA
A relation may not have a super key. (a) True (b)False
A company that provides a movie-streaming subscription service uses a relational database to store information on movies to answer customer questions. Each entry in the database contains the following items: Movie ID (the primary key), movie title, year made, movie type, MPAA rating, starring actor #1, starring actor #2, starring actor #3, and director. Movie types are action, comedy, family, drama, horror, science fiction, and western. MPAA ratings are G, PG, PG-13, R, NC-17, and NR (not rated). Using a graphics program, develop an entity-relationship diagram for a database application for this database.
Convert this table to a relation in first normal form by entering appropriate data in the table. What are the determinants in this relation?
The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.