Consider the following relations for a database that keeps track of orders: orderLines(lineNumber, productID,orderNumber,quantity) products (productID,productName,price,categoryID) orders(OrderNumber,customerID,order Date) categories(categoryID,categoryDescription) List the foreign keys that are in these relations (The FKs are not currently identified any attributes are foreign keys to relations that are not listed above. There are three relationships in the above four relations. One of the relationships is orderLines and products, the second is between orderLines and orders, and the third products and categories. Specify the attributes that would be foreign keys in these relations.

Consider the following relations for a database that keeps track of orders: orderLines(lineNumber, productID,orderNumber,quantity) products (productID,productName,price,categoryID) orders(OrderNumber,customerID,order Date) categories(categoryID,categoryDescription) List the foreign keys that are in these relations (The FKs are not currently identified any attributes are foreign keys to relations that are not listed above. There are three relationships in the above four relations. One of the relationships is orderLines and products, the second is between orderLines and orders, and the third products and categories. Specify the attributes that would be foreign keys in these relations.

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

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…
Let us consider the following relational database. Students(stuID, lastName, firstName, major, gpa) Faculty(facID, name, deptName, rank) Classes(classNumber, facID, schedule, room) Enrolls(stuID, classNumber, grade) The column facID of relation Classes that references the table Faculty, The column StuID of relation Enrolls that references table Students, and The column classNunber of relation Enrolls that references table Classes. The following SQL statement is intended to add a record to the table Students. Assume that the entered value for each column is appropriate. In other words, there is no domain constraint violation. INSERT INTO Students(stuID, lastName, firstName, major) VALUES('950555111', 'Anna' 'Smith', 'BSIT'); However, this statement does not work correctly. Briefly explain why and list the correct SQL statement.
Consider the following relational schema for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price, bookCoverType, contractDate) Collection (Title, Author, Catalog_no) Assume {Author, Title} is the key for both relations Additional functional dependencies are Title,Author --> Catalog_no Catalog_no --> Publisher, Year, bookCoverType Publisher, bookCoverType --> Price Author --> contractDate a) Explain what normal form the relation is in. b) Apply normalization until the 3rd State reasons behind each normalization
Consider the relation r(A, B, C), where the characteristic A serves as the index to the relationship. Give an example of a question that can only be answered by looking at the index, rather than the tuples in the relationship, and why this is so. (Index-only plans are query plans that solely make use of the index and do not touch the underlying relational database.)
Consider the relation r(A, B, C), where the index is the attribute A. Give an example of a query that can only be answered by looking at the index rather than the relationship's tuples. (Index-only plans are query plans that rely just on the index rather than the actual relation.)
Given the following relational schema (Hint: the bold text represents a primary key), Professor(emp_num, emp_fname, emp_lname, emp_dob, dept_code, prof_ext)Class (class_code, course_code, class_section, class_time, class_room, emp_num)Course (course_code, course_name, crs_credits, dept_code) Write a relation algebra to find all "Database Design and Implementation" classes including section, time, room, and professor name (first name and last name). Hint: "Database Design and Implementation" is the course name
Database Systems Question 6. Consider the following relation: Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity) FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address FD2 - Customer_ID -> Customer_Name, Customer_Address FD3 - Product_ID -> Product_Description, Price FD4 - Order_ID, Product_ID -> Order_Quantity What are the candidate keys of this relation? Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF. Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF. Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.
Please answer the following relational database ques Given a relation schema R = {A, B, C, D, E} and a set of functional dependencies Σ = {CD->E, B->C, AE->B, D->AC}(1) Check if Σ implies BE->AC. Justify your answer.(2) Check if BD is a candidate key in R. Justify your answer.(3) Let Σ’ ={D->E, B->C, AE->B, D->AC}. Are Σ and Σ' equivalent? Justify your answer.
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…
QUESTION 7 Consider the database schema below: Company (ID: integer, Name: String (unique), Address) Department (No: integer, CompanyID: Integer, DepartmentName: String) Is it valid to have the same Company name to be repeated with two different IDs in Company relation? Yes. No, violates key constraint. No, violates entity Integrity constraint No, violates referential integrity constraint. No, violates domain constraints.
Consider a relational database for an online hotel booking company. The database consisting ofthe following tables (where the primary keys are underlined): Hotel (hId, hName, hAddress, hCity) Guest(gId, gName, gAddress, gCity) Room(hid, roomNo, type, price) Booking(gId, hId, roomNo, fromDate, year, noOfDays)Where hId and gId are identifiers for the hotels and the guests,and the Booking relation indicated that a guest booked a hotel room for a specified number of days(noOfDays) starting from fromDate of a given year. For instance, a tuple < g12345, h5555, 220,Jan05, 2016, 15> in Booking indicates that the guest g12345 booked room 220 of the h5555 hotelfor 8 days starting on Jan 5, 2016. The attribute "gAddress" records the home address of theguests.Write the following queries in relational algebra (1) Return thename of guests who have booked a hotel room in NYC in January 2016 (i.e.,fromDate between 01/01 and 01/31 and year=2016).(2) Return thename of guests who have booked a…
Consider a database that consists of the following relations.SUPpLIER(Sno. Sname)PART(Pno, Pname)PROJECT(Jno, Jname)SUPPLY(Sno, Pno, Jno)The database records information about suppliers, parts, and projectsandincludes a ternary relationship between suppliers, parts, and projects.Thisrelationship is a many-many-many relationships. Specify and execute thefollowingqueries using the relational algebraRetrieve the part numbers that are supplied to exactly two projects.b. Retrieve the names of suppliers who supply more than two parts toproject J11c. Retrieve the part numbers that are supplied by every supplier.d. Retrieve the project names that are supplied by supplier S1' only.e. Retrieve the names of suppliers who supply at least two different partseach to at least two different projects.