A) The following relations kind a part of a on-line database (the relations area unit self- explanatory): CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown, Balance, Cname) ORDER(Order.#, Date, Cust#.) ORDERLINE(Order#, Part#., Amount-Ordered) PART(Part#., Desc, Stock, Item-Class, Unit -Price) a. Design a physical ER for the above scenario. b. With respect to this relative schema, write SQL statements for the subsequent queries: 1. List the name of the client United Nations agency has placed Order 123 (i.e. Order: = 123). 2. List the names of shoppers United Nations agency in Cardiff and have ordered half 456 (i.e. Part. 456). 3. List the order numbers (Order) for orders that contain a minimum of three elements and also the quantity ordered are minimum of ten. 4. List the outline (Desc), of these elements that the typical quantity ordered is bigger than the number ordered for half .6 (Part. = 456) so as 123.(Order..123).

A) The following relations kind a part of a on-line database (the relations area unit self- explanatory): CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown, Balance, Cname) ORDER(Order.#, Date, Cust#.) ORDERLINE(Order#, Part#., Amount-Ordered) PART(Part#., Desc, Stock, Item-Class, Unit -Price) a. Design a physical ER for the above scenario. b. With respect to this relative schema, write SQL statements for the subsequent queries: 1. List the name of the client United Nations agency has placed Order 123 (i.e. Order: = 123). 2. List the names of shoppers United Nations agency in Cardiff and have ordered half 456 (i.e. Part. 456). 3. List the order numbers (Order) for orders that contain a minimum of three elements and also the quantity ordered are minimum of ten. 4. List the outline (Desc), of these elements that the typical quantity ordered is bigger than the number ordered for half .6 (Part. = 456) so as 123.(Order..123).

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

32. In a relational model, relations are termed as a. Tuples b. Attributes c. Rows d. Tables
1. What is a set? A relation? A function? 2. Explain the difference between a partial and a total function. 3. Explain the difference between a relation and a function.
1. A movie may have many actors, and an actor can act in many movies. An actor can play more than one role in the same movie. Suppose we try to represent this in our database using an Actor table, a Movie table, and a Role table. The Role table has a foreign key to reference the Actor table, plus the name of the role and the title of the movie. a) There might be actors who do not have roles in the Role table b) The actor referenced might not exist in the table c) A role might list a movie title that does not exist in the Movie table d) There could be more than one actor with the same name 2. Suppose we have the following relational model: Movie(mov_id(PK), title, yr) Person(pid(PK), fname, lname, gender) Acts_In(actor_id(PFK), movie_id(PFK), role) -- actor_id references Person, movie_id references Movie What would be true of the following query? SELECT fname, lname FROM Movie m, Acts_In a, Person p WHERE mov_id = movie_id AND actor_id = pid AND yr = 2022 a) It…
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.
SpecificationFunctional DependencyConsider the relational schemas given below and the respective sets of functional dependencies valid in the schemas. For each one of the relational schemas identify its highest normal form. Remember that the identification of a normal form requires analysis of the valid functional dependencies and the minimal keys. TRUCK(registration#, type, owner, driver, date-used)The values of attributes of a relational table TRUCK satisfy the following properties:- a truck has a unique registration number,- a truck has only one owner,- a truck is used only once per day,- an owner owns many trucks and driver uses many trucks.
3. In mathematical term Row is referred as a. Relation b. Attribute c. Tuple d. Domain
QUESTION 1 SQL: Consider the following database schema for flight reservation database. A flight can be booked by many passengers, and a passenger can book different flights. For each booking, the date of the flight and price are recorded. The database schema is given below Flight (FID:int, Airline:string(unique), DepartingAirport:string, ArrivalAirport:string, Rating: int (1,2,3,4,5) ) Booking (FlightID: int, PassengerCPR: int, Date: date, Time: time, Price: double) Passenger (CPR:int, FirstName: String, LastName: String, Address:String) Write SQL Code to: Create the Flight Table.List the Departing Airport and Arrival Airport for all flights with rating 4 or 5.
Store the following fields for a library database: AuthorCode, AuthorName, BookTitle, BorrowerAddress, BorrowerName, BorrowerCardNumber, CopiesOfBook, ISBN (International Standard Book Number), LoanDate, PublisherCode, PublisherName, and PublisherAddress. A one-to-many relationship exists between publishers and books. Many-to-many relationships exist between authors and books and between borrowers and books.a. Name the entities for the library database b. Without creating a set of dependency diagrams, write the relational schema that meet 3rd NF requirements. c. Draw the Crow’s Food entity-relationship diagram for the library database.
The properties of the relation object can be used to implement the master-detail functionality which most appropriate for your application. You can delete a master-detail relation by selecting it in the Object Navigator and choosing Navigator => Delete. Discuss the Deletion of Relations in detail.
14. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. a. Rows b. Key c. Attribute d. Fields
CSC 472 Introduction to Database Systems Project Consider the contents of output tuples generated by a join operator. The advantage of "late materialization" approach is that future operators in the query plan never need to go back to the base tables to get more data. Group of answer choices True False
Course: Principles of Database please solve it within 30 minutes. please please, pleaseThank you Single Choice Questions 11. Given a relation R and a condition f for selecting from relation R, the correct relational algebraic expression is ( ). A、R X R B、 R ⋈ R C、sf(R) D、 ∏f(R) 12. If relations R and S have a common attribute set Y, when executing , tuples that do not have matching values on attribute Y will be discarded. To avoid discarding those tuples, which operation should be used? ( ) A. Aggregation. B. Grouping. C. Outer union. D. Outer join. 13. To address the "lost update" problem, a transaction must obtain ( ) before updating a data set. A. Shared lock (S-lock). B. Exclusive lock (X-lock). C. Shared lock (S-lock) and exclusive lock (X-lock). D. Shared lock (S-lock) or exclusive lock (X-lock). 14. If, during the system operation, data stored on external storage is…