Question 9 One-to-one, one-to-many, and many-to-many are descriptions of "parent-child" database relationships called: O associations. O constructions. O combinations. O linkages. Question 10 The database relationship example of each team having one home stadium and each home stadium having one team is an example of what type of relationship? O None of these. O One-to-many 1 O Many-to-many O One-to-one

Question 9 One-to-one, one-to-many, and many-to-many are descriptions of "parent-child" database relationships called: O associations. O constructions. O combinations. O linkages. Question 10 The database relationship example of each team having one home stadium and each home stadium having one team is an example of what type of relationship? O None of these. O One-to-many 1 O Many-to-many O One-to-one

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

Doctors have id. name. date of birth. and specialty. Patients have id. name, and date of birth. and address. Medicines have name. patent number, and milligrams We want to build A database that keeps track of the medicines prescribed by a doctor to patients The prescription process happens in a hospital. (a) Draw a complete Entity-Relationship diagram for the description above. You must include all the details, such as keys, weak entities (if any). cardinality constraints., etc Your diagram must use n-ary relationships You must use arrow notation Your diagram must avoid redundancy.
Which of the following is a key part of physical design in an entity relationship model? O This model converts attributes into columns. O This model does not depend on the database management software or the hardware used to implement the model. O This model avoids any database model-specific details. This model resolves the many-to-many relationships to multiple one-to- many relationships.
Design a Relational Database by Mapping the following Entity-Relationship Diagram (ERD) into Relational Model. You must clearly determine the PK of each relation. Also, you should show the links between FKs and PKs in your answer. SName Owner SHIP MOVEMENT PName HISTORY HOME PORT SHIP PORT Latitude (0,") VISITS (0.") Timestamp Longitude N N N (1.1) IN TYPE ON 1 1 Date Time StartDate VISITS Type EndDate Tonnage SHIP TYPE Name STATE/COUNTRY Name SEA/OCEAN/LAKE Hull Continent
Relations describe the intersection between two axes, x and y. For example, a table (tuple) found in a database contains columns (attributes) and rows (records or observations). Database and Geospatial Mapping Application developers rely on tables and cartesian coordinate systems to adhere to the rules of relational database theory so that integrity in the location is preserved. Tables should only contain records that relate to the columns found in that table and the data domain determines what records should be stored in a given table. Database administrators can check for integrity in relationships within and between tables using structured query language (SQL). What other computer-science or IT jobs rely on relations?
Your job as a database designer is to design a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, photograph, sculpture), and its price must be stored. Pieces of artwork also classified into groups of various kinds, for example, portraits, still lives, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group and property. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique ID, name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer tends to like. Draw the ER diagram for the database.
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.
1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.
Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…
Question 1 for a new airline company with the following specifications: Utilize the different concepts we discussed to design a database (single ER diagram) 1. Pilots are identified by Pilot ID, and the SSN, first and last-name, full address, and salary must be recorded for each pilot. 2. Pilot Profiles are identified by Profile ID, and the food preferences (one or more values) and favorite destinations (one or more values) must be recorded for each profile. 3. Each pilot has only one profile; and If a pilot is deleted, you need not keep track of his/her stored profile. 4. Aircraft-Models are identified by Model ID, and the name, capacity, and cruising-range must be recorded for each Aircraft-Model. 5. Each Pilot is certified for one or more Aircraft-Model, and the date of each certification should be recorded. 6. Flights are identified by Flight ID, and the from-airport, to-airport, distance, departure-time, and arrival- time must be recorded for each flight. 7. Pilots can operate…