2. isa c) B(d,f) d) A(d,e,g) B A isa C Translate the above E/R diagram to relations using the "Object-oriented" approach, the "E/R" approach, and the "NULLS" approach. Then, identify which of the following sets of attributes is the schema for some relation in the "E/R" approach, but does not appear if we use either the "object-oriented" ap- proach or the "NULL's" approach. a) A(d,e,f,g) b) B(d,e,f)

2. isa c) B(d,f) d) A(d,e,g) B A isa C Translate the above E/R diagram to relations using the "Object-oriented" approach, the "E/R" approach, and the "NULLS" approach. Then, identify which of the following sets of attributes is the schema for some relation in the "E/R" approach, but does not appear if we use either the "object-oriented" ap- proach or the "NULL's" approach. a) A(d,e,f,g) b) B(d,e,f)

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

just answer true/false a]Disjointness means that every entity of a supertype must be an entity in one of the subtypes in the generalization hierarchy. b]Record is a set of more fields that describe a person, place or thing. c]Cardinality is the number of tuples in a relation. d]Referential integrity must have null values only.
Proper Explanation
Create a diagram with one entity set, P erson, with one identifying attribute, Name. For the P erson entity set create recursive relationship sets, has mother, has father, and has children. Add appropriate roles (i.e. mother, father, child, parent) to the recursive refationship sets. (In an ER đíagram, we denote roſes by writing the role name next to the connection between an entity set and a relationship set. Be sure to specify the cardinalities of the relationship possibilities|a person has one mother, one father, and zero or more children). sets appropriately according to biological VER
This question concerns the logical design of a relation schema LOAN describing the borrowing of a book at a library. If a tuple is in this relation, it means that a specific copy with identifica- tion number catalogNo has been borrowed by a library member with identification number memberNo on dateOut (borrowing day) and has been returned on dateReturn (return day). If the book has not yet been returned dateReturn is null. LOAN (catalogNo, dateOut, memberNo, dateReturn) (a) What would the following functional dependency mean? { dateOut, memberNo} → dateReturn (b) Give all full functional dependencies for schema LOAN, assuming that a book can be borrowed just once per day, that members can borrow many books on any given day, and that members can borrow the same book several times.
Break down the concept of inherited attributes and how they work in the context of interconnected objects.
23 of 40 Let R(A, B, C, D, E, F) be a relation with FD's: {D → CE, C → BDE, E → AD, AF → E, B → DF}. Which of the following statements is correct? Select one: O Ris in BCNF but not in 3NF. O Ris in 3NF but not in BCNF. O Ris not in 3NF and not in BCNF. O R is in 3NF and in BCNF.
List all nontrivial functional dependencies satisfied by the relation of Figure7.18.
1) Design an Object-Relational geodatabase, E-R diagram, and schema from the following elements. Subcatchments (S1, S2, S3). The study region is divided into multiple subcatchments where water is collected. Each subcatchment is described with a unique subcatchment ID, the area (square km), the average slope and the location (polygon). Rain Gages (R1, R2). A rain gage supplies precipitation for one or more subcatchments, and a subcatchment may have one or more rain gages. For example, in the Figure, R1 supplies precipitation data for S1 and S3, and R2 for S1 and S2. Each rain gage is described by a unique gage ID, hourly precipitation (mm), the time (year, month, day, hour) when the hourly precipitation is collected, and the location (point). Conduits (C1, C2, C3, C4). Conduits are the channels that move water to an outfall in the drainage system. Each conduit is described by a unique conduit ID, the length and the location (line). Junctions (J1, J2, J3, J4). A junction is the…
let R be a relation defined on the set z by aRb if a < b. What property/properties are violated? A. Symmetric & transitive B. Reflexive & Symmetric C. Reflexive & Transitive D. All three properties
COM. Q. CUSTOMER (CID, NAME, STREET, CITY, STATE, AGE) SALE (PID, CID, DATE, COST) PART (PID, PNAME, COLOR) The meaning of these relations is straightforward; for example, SALE has one tuple for every part sold to a customer. Primary key attributes are underlined. For instance, PID and CID together form the primary key of relation SALE. SALE.PID is a foreign key that refers to PART.PID, while SALE.CID is a foreign key that refers to CUSTOMER.CID. Write SQL statements for the following retrieval and update operations. Retrieve the names of all the customers from the city of "Trenton' who bought a part at a cost less than $50. No duplicates should appear in the answer. Retrieve the names of red parts bought by a customer who is younger than 40 and from a customer who is older than 40. Delete all parts that are never bought by a customer from "Trenton" (this is a data change statement). Retrieve the names of the customers who never bought a green part. Retrieve the names of the…
Question 2: The UML display the mediator pattern, describe uml and the relations, build the code in java Mediator Colleague Extends Concrete Colleague Extends Concrete Mediator Extends Concrete Colleague A
In Discrete Math