Register

Recent questions tagged database-design

97
views
0 answers
0 votes
Can a candidate key for a composite attribute be called a composite key?
Let's take an example of student entity typeNameClassSectionAddress (Line1, Line2, City, State, Country, PinCode)Since composite attribute holds multiple atomic attribute...
User Avatar
611
views
0 answers
0 votes
DBMS -- Book Confusion
which is best book for DBMS korth or navathe ?since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language...
User Avatar
351
views
1 answers
2 votes
GATE ACADEMY TEST SERIES
Under a relational database if table A has a foreign key constraint referencing to another table B, then Each tuple in A is related to zero or one tuple of B.Each tuple i...
User Avatar
259
views
0 answers
0 votes
UGC NET CSE | December 2005 | Part 2 | Question: 18
In a relational schema, each tuple is divided in fields called :RelationsDomainsQueriesAll the above
User Avatar
1.3k
views
2 answers
1 votes
UGC NET CSE | January 2017 | Part 2 | Question: 16
An attribute $A$ of datatype varchar $(20)$ has value 'Ram' and the attribute $B$ of datatype char $(20)$ has value 'Sita' in oracle. The attribute $A$ has ________ memor...
User Avatar
858
views
1 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 29 (Page No. 321)
Explain the distinction between total and partial constraints.
User Avatar
889
views
1 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 28 (Page No. 321)
Explain the distinction between disjoint and overlapping constraints.
User Avatar
569
views
0 answers
2 votes
DBMS Korth Edition 6 Exercise 7 Question 27 (Page No. 321)
Explain the distinction between condition-defined and user-defined constraints.Which of these constraints can the system check automatically?Explain your answer.
User Avatar
2.0k
views
0 answers
5 votes
DBMS Korth Edition 6 Exercise 7 Question 26 (Page No. 321)
Design a generalization-specialization hierarchy for a motor vehicle salescompany. The company sells motorcycles, passenger cars, vans, and buses.Justify your placement o...
User Avatar
867
views
0 answers
2 votes
DBMS Korth Edition 6 Exercise 7 Question 23 (Page No. 320)
Design a database for an airline. The database must keep track of customersand their reservations, flights and their status, seat assignments onindividual flights, and th...
User Avatar
1.6k
views
0 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 22 (Page No. 319-320)
Design a database for a worldwide package delivery company (e.g., DHLor FedEx). The database must be able to keep track of customers (who shipitems) and customers (who re...
User Avatar
1.6k
views
0 answers
4 votes
DBMS Korth Edition 6 Exercise 7 Question 21 (Page No. 319)
Design a database for an automobile company to provide to its dealers toassist them in maintaining customer records and dealer inventory and toassist sales staff in order...
User Avatar
3.1k
views
0 answers
4 votes
DBMS Korth Edition 6 Exercise 7 Question 20 (Page No. 319-320)
Consider the E-R diagram in Figure given below, which models an online bookstore.a. List the entity sets and their primary keys. b. Suppose the bookstore adds Blu-ray dis...
User Avatar
466
views
0 answers
1 votes
DBMS Korth Edition 6 Exercise 7 Question 19 (Page No. 319)
We can convert any weak entity set to a strong entity set by simply addingappropriate attributes. Why, then, do we have weak entity sets?
User Avatar
460
views
1 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 18 (Page No. 319)
Explain the difference between a weak and a strong entity set.
User Avatar
772
views
1 answers
–1 votes
DBMS Korth Edition 6 Exercise 7 Question 15 (Page No. 319)
Construct an E-R diagram for a hospital with a set of patients and a set ofmedical doctors. Associate with each patient a log of the various tests andexaminations conduct...
User Avatar
1.6k
views
2 answers
2 votes
DBMS Korth Edition 6 Exercise 7 Question 14 (Page No. 318)
Explain the distinctions among the terms primary key, candidate key, andsuperkey.
User Avatar
648
views
1 answers
2 votes
DBMS Korth Edition 6 Exercise 7 Question 13 (Page No. 318)
Temporal changes: An E-R diagram usually models the state of an enterpriseat a point in time. Suppose we wish to track temporal changes, that is,changes to data over time...
User Avatar
573
views
0 answers
1 votes
DBMS Korth Edition 6 Exercise 7 Question 12 (Page No. 317-318)
Figure shows a lattice structure of generalization and specialization(attributes not shown). For entity sets A, B, and C, explain how attributes are inherited from the hi...
User Avatar
783
views
0 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 11 (Page No. 317)
In SQL, foreign key constraints can only reference the primary key attributesof the referenced relation, or other attributes declared to be a super key usingthe unique co...
User Avatar
708
views
0 answers
4 votes
DBMS Korth Edition 6 Exercise 7 Question 10 (Page No. 317)
Consider a many-to-one relationship R between entity sets A and B. Supposethe relation created from R is combined with the relation created fromA. In SQL, attributes part...
User Avatar
341
views
0 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 9 (Page No. 317)
Suppose the advisor relationship was one-to-one. What extra constraintsare required on the relation advisor to ensure that the one-to-one cardinalityconstraint is enforce...
User Avatar
295
views
0 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 8 (Page No. 317)
Consider a relation such as sec_course, generated from a many-to-one relationshipsec_course. Do the primary and foreign key constraints created onthe relation enforce the...
User Avatar
1.1k
views
0 answers
2 votes
DBMS Korth Edition 6 Exercise 7 Question 7 (Page No. 317)
A weak entity set can always be made into a strong entity set by adding toits attributes the primary-key attributes of its identifying entity set. Outlinewhat sort of red...
User Avatar
599
views
0 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 6 (Page No. 316-317)
Consider the representation of a ternary relationship using binary relationshipsas described in this book and illustrated in Figure (b) (attributesnot shown)a. Show a sim...
User Avatar
592
views
0 answers
1 votes
DBMS Korth Edition 6 Exercise 7 Question 5 (Page No. 316)
An E-R diagram can be viewed as a graph. What do the following mean interms of the structure of an enterprise schema?a. The graph is disconnected.b. The graph has a cycle...
User Avatar
404
views
0 answers
1 votes
DBMS Korth Edition 6 Exercise 7 Question 4 (Page No. 316)
Consider an E-R diagram in which the same entity set appears several times,with its attributes repeated in more than one occurrence. Why is allowingthis redundancy a bad...
User Avatar
968
views
0 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 3,17 (Page No. 316-319)
Design an E-R diagram for keeping track of the exploits of your favoritesports team. You should store the matches played, the scores in each match,the players in each mat...
User Avatar
387
views
0 answers
0 votes
DBMS Korth Edition 6 Exercise 7 Question 2 (Page No. 315)
Consider a database used to record the marks that students get in differentexams of different course offerings (sections).a. Construct an E-R diagram that models exams as...
User Avatar
Page: