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 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

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,…
Create a conceptual schema for the following database domain. To make it completely clear, only one (the final) conceptual schema is expected. A book is described by ISBN and a title. ISBN uniquely identifies each book. A book consists of many chapters. A chapter is described by a chapter number, title and topic. Each chapter has a unique number within a book. A chapter belongs to one book only. A book is written by one or more authors. An author can write one or more books. An author is described by the first name, last name, date of birth, and country the author comes from. A triple of values: (first name, last name and date of birth) uniquely identifies each author. We have three types of books: textbooks, fiction books and biographies. A textbook is additionally described by the titles of course it has been applied to. A textbook can be applied to none or more courses. i need answer with diagram
Consider a database that includes the entity sets student, course, and sectionfrom the university schema and that additionally records the marks that studentsreceive in different exams of different sections.a. Construct an E-R diagram that models exams as entities and uses a ternaryrelationship as part of the design.b. Construct an alternative E-R diagram that uses only a binary relationshipbetween student and section. Make sure that only one relationship existsbetween a particular student and section pair, yet you can represent themarks that a student gets in different exams.
Create a database Entity and Relationship Diagram (ERD) for the following applicationThe Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager Personal information form: It contains a list of the user's…
Develop an EER model for the following situation using EER 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 DVD, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside of the scope of this project. • Computer is identified by CType ID and has attributes of Computer Type and Type Description, Disk Capacity, and Processor Speed. Please note: as with Media Type, we are tracking…
A well-structured database starts from an effective Entity Relationship Diagram (ERD). For this part of the question, you will need to sketch an ERD for the following gym scenario: A member must have a member ID, name and contact number, can be enrolled in one or more gym session. A gym session can be enrolled in by one or more members. Each gym session is identified by a session ID, and has a name, date and instructor details (Instructor ID). An instructor has an instructor ID, name and contact number, and must only be assigned to one gym session. A gym session can have one or more instructors assigned in it.” *show entities, relationship types and cardinalities. Crow’s foot model notations recommended.
An objective of this task is to denormalize a conceptual schema to speed up processing of a given class of applications. The following conceptual schema represents a database domain where the contract and permanent employees are assigned to the projects. (see image below) Requirements Steps Involved: - Elimination of generalization using Association, Subset or Superset method - Simplifications: •Elimination of association classes •Elimination of link attributes •Elimination of many-to-many associations Perform simplification of the conceptual schema above and re-draw the simplified conceptual schema.
Please written by computer source Part I - Modeling You are building a database for a comic book store customer management system. Given the database specification below, your job is to turn the specification into an ER diagram. Your notation must be consistent with the notation used in our lecture notes. You can use all constructs and notations discussed in our lecture notes and nothing else (i.e.. oven notations used in the textbooks but not in our lectures cannot be used). Your ER diagram should capture all the information and constraints in the specification but, at the same time, be minimal. It means that redundant entities, relationships, attributes and constraints should be avoided. You may use any drawing tool of your choice (for example, Dia, diagrams.net, Lucidchart, etc.) to draw your ER diagram. Hand drawings will not be accepted. Database Specification The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should…
Consider the following Scenario.Design a database for an airline. The database must keep track of customers andtheir reservations, flights and their status, seat assignments on individual flights,and the schedule and routing of future flights. Your design should include an E-Rdiagram, a set of relational schemas, and a list of constraints, including primary-keyand foreign-key constraints.Please determine the entities, attributes and relationships that should exist in thedatabase and draw an E-R diagram.
Computer Science Design an OO schema for a database application that you are interested in.Construct an EER schema for the application, and then create the corresponding classes in ODL. Specify a number of methods for each class, andthen specify queries in OQL for your database application.
A client wishes to retrieve some domain object, say dom, from the database. Describe a possible problem with this scenario. Extend your design and provide a dynamic design model (focusing on the passage of time) that can solve the problem. Note: Do not provide any statements to describe the solution. The solution should be apparent in your design. Non-functional requirements include integrity of data and resource utilization.
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.