Which statement is NOT CORRECT when mapping the above EER model to a relational model? AIRLINE CUSTOMER O.N FLIGHT ON COMMERCIAL FLIGHT flightNR PRIVATE FLIGHT A new relation should be created to model the EER relationship type between customer and commercial flight. A new relation should be created to model the EER relationship type between flight and airline.correct O The total EER specialization can be mapped to the relational model without loss of semantics. The Airline's primary key should be included as a NOT NULL foreign key in the relation 'Flight!

Which statement is NOT CORRECT when mapping the above EER model to a relational model? AIRLINE CUSTOMER O.N FLIGHT ON COMMERCIAL FLIGHT flightNR PRIVATE FLIGHT A new relation should be created to model the EER relationship type between customer and commercial flight. A new relation should be created to model the EER relationship type between flight and airline.correct O The total EER specialization can be mapped to the relational model without loss of semantics. The Airline's primary key should be included as a NOT NULL foreign key in the relation 'Flight!

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

Here is a table representing a relation named K: ABC 012 345 678 Identify: 1. The attributes of R. 2. The schema of R. 3. The tuples of R. 4. The components of the tuples for each attribute of R. Which of the following is NOT a true statement about relation R? OA. The schema of R is R(A,B,C). O B. (0,3,6) is a tuple of R. O C.4 is the value of the B-component of one of the tuples of R. O D. (3,4,5) is a tuple of R.
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.
Map the given EER into the relational model. Three are three options for mapping a specialization. Please use the option of "Option1: Create a table for each class (both superclass and subclass)". Please include all the relations and views (if there is any). All assignments' submissions in this course must be typed and submitted electronically through Canvas. You must submit a PDF file. Files in another format will not be accepted. SSN Salary Student Name ΤΑ STUDENT Address N Email Grade Enrolled In Course_No. M (No_of_Students ONLINE COURSE URL Graded by N Building Room Id. Course Name COURSE N IN PERSON COURSE N 1 Taught by Takes Place in Room No CLASSROOM 1 Title Instructor ID INSTRUCTOR Capacity Class_time Instructor Name
Which one is correct * Consider the following ER diagram illustrating the relationship of customers and banks. DateActCreated BName BankID Cname Bank Account Customer NID Select from among the following candidates for relations, if the above ER is mapped into a relational model. 1-Customer(NID(pk).CName) 2-Account(DateAccCreated(pk).BName,CName) 3-Bank(BanklD(pk),NID.BName) 4-Bank(BankID(pk).BName) 5-Account(BankID(pk), NID (pk),BName, DateAccCreated) O 1,4 and 5 O 1,2 and 4 1,3 and 5 O 1,2 and 3
Consider the following relational schema, representing five relations describing shopping transactions andinformation about credit cards generating them [the used notation is explained above].SHOPPINGTRANSACTION (TransId, Date, Amount, Currency, ExchangeRate, CardNbrCREDITCARD, StoreIdSTORE)CREDITCARD (CardNbr, CardTypeCARDTYPE, CardOwnerOWNER, ExpDate, Limit)OWNER (OwnerId, Name, Surname, BirthDate, Job, IncomeLevel, Level)CARDTYPE (CardType, Circuit, Issuer, Address, Country, CardName, Color)STORE (StoreId, Name, Address, Country, Zone, Web, Email, Type)1) Answer the following questions considering the domain described by the previous relational schema:1.1. How many transactions can be generated by a given credit card? (provide the minimum and themaximum number)1.2. How many shopping transactions occurred in the same store can be associated with a givenidentifier? (provide the minimum and the maximum number)2) Write the SQL query representing the following request:2.1. Determine the…
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. D
Create an Entity-Relationship Model for the Queen Anne Curiosity Shop The first assignment for the class project is to create an entity-relationship model of the Queen Anne Curiosity Shop database. This assignment requires you to apply the knowledge gained from study of chapter 4 of the textbook. You will create the entity-relationship model using the ERDPlus database modeling tool. The Queen Anne Curiosity Shop database contains the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, EmailAddress) EMPLOYEE (EmployeeID, LastName, FirstName, Phone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) Note that the above table descriptions follow the textbook convention:…
Consider the following relations for a simple airport databas Hangars (hangNo, capacity, location, status) AirplaneTypes (Model, capacity, weight) Airplanes (regNo, model, hangNO) Owners (owner, name, address, phone, ssn) Owns (regNo, ownID, startedDate) There are four foreign keys for this database: 1. The attribute hangNo of the relation Airplanes that references the relation Hangars, 2. The attribute model of the relation Airplanes that references the relation AirplaneTypes, 3. The attribute regNo of the relation Owns that references the relation Airplanes, and 4. The attribute ownID of the relation Owns that references the relation Owner. Q1: Write SQL statements to define the above relation Hangars. You should choose a suitable data type and/or daya size for each column and be sure to declare appropriate integrity constraint(s). Q2. Which of the following SQL statements is used to define the above relation Airplanes? Ensure the data type and size for each attribute are…
Develop an Entity Relationships Diagram (ERD) based on the relational schemas in the 3NF for the starting relational schema in un-normalized form presented below. UNF:Order(OrderID, OrderDate, CustID, CustName, CustPhone, CCNum, CCExpDate, CCBank, BnkContName, BnkContPhone, CustEmail, OrderIP, SiteRefFrom, ShipStreet, ShipCity, ShipSt, ShipZip, OrderLineNum, ItemID, ItemName, ItemDesc, ItemQtyOrdered,ItemListPrice, ItemSalePrice, ItemQtyShip, ShipCharge, Tax, TotalDue)
1. Consider the following relations:Student (snum: integer, sname: string, major: string, level: string, age: integer)Class (name: string, meets at: string, room: string, fid: integer)Enrolled (snum: integer, cname: string)Faculty (fid: integer, fname: string, deptid: integer)The meaning of these relations is straightforward; for example, Enrolled has onerecord per student-class pair such that the student is enrolled in the class. Level is atwo character code with 4 different values (example: Junior: A Level etc)Write the following queries in SQL. No duplicates should be printed in any of theanswers.i. Find the names of all Juniors (level = A Level) who are enrolled in a classtaught by Prof. Kwizeraii. ii. Find the names of all classes that either meet in room R128 or have five ormore Students enrolled.iii. Find the names of all students who are enrolled in two classes that meet atthe same time.
Create a database schema for a dental clinic. The dental clinic has five relations, Patients, Doctors, staff, Appointments, Payments. You are free to choose the attributes for each relation, and you are required to show the Primary keys. Giving the following schema create an ER diagram for this Supermarket database, and show the primary keys, multivalued attributes, composite attributes, and relationship types. Supermarket has CUSTOMERS (CustomerID , First_Name, Last_Name) Supermarket has EMPLOYEES (EmployeeID, Name, Email, PhoneNo, Address, Salary) Each Employee purchase PRODUCTS (ProductID, Product_Type) Employee creates INVOICES( InvoiceID, Amount_Paid, Invoice_Date)
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.