Question 12.1 Use the object definition language ODL of the ODMG object model to specify an object database schena klass definitions) capturing the requirements from the following ER diagram about a publisher enterprise. Note that you can use any appropriate data types for your schema design, and no specification of behavior is required. Catato Name Tide M Publcaton Produce Publisher Page count Format Medum Address Duraton City Sreet Book Recording Questions 12.2 ts) List two popular heuristic rules used by a heuristic-based query optimizer in a relational DBMS.

Question 12.1 Use the object definition language ODL of the ODMG object model to specify an object database schena klass definitions) capturing the requirements from the following ER diagram about a publisher enterprise. Note that you can use any appropriate data types for your schema design, and no specification of behavior is required. Catato Name Tide M Publcaton Produce Publisher Page count Format Medum Address Duraton City Sreet Book Recording Questions 12.2 ts) List two popular heuristic rules used by a heuristic-based query optimizer in a relational DBMS.

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Draw the relationships and entities model for each of the following: * in the traditional way* for example: see the pic??. In the database of the library, the author can author more than one book, and the book can be subscribed toWritten by more than one author
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…
Question 23. The database interface of a library allows searching only for a single attribute (such as Titleor Author ) in each query. Your friend decided to extend it’s functionality and wrote an algorithm that allowssearching for books that satisfy multiple predicates over single attributes in conjunction. He tells you the algorithmreuses the already implemented query functionality and works by intersecting the results ( book id’s ) of queriesover single attributes.Which of the following assumptions on your friend’s algorithm are plausible?a) Its worst-case run-time necessarily increases exponentially with respect to the number of attributes in thequery.b) Its worst-case run-time depends on the length of the longest result of the single-attribute queries.c) It might be implemented using an join.d) It might be implemented using sorting.
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules: • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type. • Media is identified by MType ID and has attributes of Media Type and Type Description. Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project. • Computer is identified by CType ID and has attributes Computer Type, Type Description,…
3- Consider a database for a university system that needs to store information about students,courses, and instructors. Each student can enroll in multiple courses, and each course can havemultiple instructors. Normalize the following schema to Third Normal Form (3NF), and showyour steps in between (1NF, 2NF).Students (StudentID, FirstName, LastName, CourseID, InstructorID)Courses (CourseID, CourseName, InstructorID)Instructors (InstructorID, FirstName, LastName)4- To keep track of office furniture, computers, printers, and other office equipment, the FOUNDITCompany uses the table structure shown below.a. Given that information, write the relational schema and draw the dependency diagram.Make sure that you label the transitive and/or partial dependencies.b. Write the relational schema and create a set of dependency diagrams that meet 3NFrequirements. Rename attributes to meet the naming conventions, and create newentities and attributes as necessary.
Please solve nd tell me te answer of relational database. With explaination. Consider the relation schema Booking={Airline, Date, Destination, FlightNo, PassengerName, Origin,PassportNo, Seat, Terminal} and the following set Σ of FDs:• Airline → Terminal• FlightNo → Airline, Origin, Destination• PassportNo → PassengerName• FlightNo, PassportNo, Date → Seat• FlightNo, Date, Seat → PassportNoWhich, for brevity, we can alias the attributes and restate as Booking={A, D, E, F, N, O, P, S, T} and Σ:• A → T• F → AOE• P → N• FPD → S• FDS → P1. Is the above relation schema Booking in BCNF? If not, identify a BCNF decomposition for Bookingand check if your BCNF decomposition is dependency-preserving. You need to include the main stepsused for identifying the BCNF decomposition. 2. Consider another set Σ1 of FDs on Bookings:• Airline → Terminal• FlightNo → Airline, Origin, Destination• PassportNo → PassengerName• FlightNo, PassportNo, Date → Terminal, Seat• FlightNo, Date, Seat → PassportNo,…
Give a relational database schema for the following: EMPLOYEE (Fname, Minit, Lname, SSN, Bdate, Address, Sex, Salary, Super_ssn, Dno) PK= Ssn FK= Super_ssn DEPARTMENT ( Dnamc, Dnumbcr, Mgr_ssn, Mgr_start_datc) PK= Dnumbcr FK= Dno DEPT_LOCATIONS (Dnumber, Dlocation) PK= Dnumber FK= Dnumbcr PROJECT (Pname, Pnumber, Plocation, Dnum) PK= Pnumber FK= Pno WORKS_ON (Essn, Pno, Hours) PK= Pno FK= ssn DEPENDENT (Essn, Dependent_name, Sex, Bdate, Relationship) PK= Essn FK= Ssn
. For each item below, specify whether the statement is true (T) or false (F). Each Database Management System (DBMS) is based on a Data Model. Database Users may desire to perform conflicting operations at the same time. For example, in an Airline Reservation System, two on-line users may see the last empty seat while trying to reserve a seat on a flight. Concurrency features of a DBMS prevents them from reserving the same seat, therefore avoiding inconsistent database states. In the Entity-Relationship Model (E-R), an Attribute maps an entity to another entity (or a set of entities). A Relationship, on the other hand, maps an entity to a primitive value. Specialization ISA is the result of taking the union of two or more lower-level entity sets to produce a higher-level entity set. It emphasizes the similarity. In the Network Data Model, relationships between record types are implemented by means of Link Types. Since…
For each item below, specify whether the statement is true (T) or false (F). __ Each Database Management System (DBMS) is based on a Data Model. __ Database Users may desire to perform conflicting operations at the same time. For example, in an Airline Reservation System, two on-line users may see the last empty seat while trying to reserve a seat on a flight. Concurrency features of a DBMS prevents them from reserving the same seat, therefore avoiding inconsistent database states. ___ In the Entity-Relationship Model (E-R), an Attribute maps an entity to another entity (or a set of entities). A Relationship, on the other hand, maps an entity to a primitive value. __ Specialization ISA is the result of taking the union of two or more lower-level entity sets to produce a higher-level entity set. It emphasizes the similarity. __ In the Network Data Model, relationships between record types are implemented by means of Link Types. Since there can be only one…
Consider a schema ? = {?,?,?,?,?} and the following set of functional dependencies: {?? → ?, ? → ??, ?? → ?} Is ? in Boyce-Codd normal form? Justify your answer.
Given the following relation(s) and the functional dependencies, what is the highest normal form the data model complies to? Note: Primary keys are indicated in bold. TaxiRide (jobID, jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddress)jobID -> jobDateTime, driverID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, driverID -> jobID, driverName, taxiID, clientID, clientName, jobPickUpAddressjobDateTime, taxiID -> jobID, driverID, driverName, clientID, clientName, jobPickUpAddressjobDateTime, clientID -> jobID, driverID, driverName, taxiID, clientName, jobPickUpAddressdriverID -> driverName, taxiIDclientID -> clientName A)1NF B)2NF C)3NF
Consider a schema R={A,B,C,D,E} and the following set of functional dependencies: {AB-> C, C->D, D->BE} Is R in Boyce-Codd normal form? Justify your answer.

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning