Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged database-design
0
votes
0
answers
1
Can a candidate key for a composite attribute be called a composite key?
Let's take an example of student entity type Name Class Section Address (Line1, Line2, City, State, Country, PinCode) Since composite attribute holds multiple atomic attributes, such that the group is treated as ... (ignoring the semantics) the combinations like {Class, Section} {Class, Address} {Name, Class, Section}
Let's take an example of student entity typeNameClassSectionAddress (Line1, Line2, City, State, Country, PinCode)Since composite attribute holds multiple atomic attribute...
tbhaxor
51
views
tbhaxor
asked
Apr 4
Databases
database-design
+
–
0
votes
0
answers
2
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 for all topics. please suggest .
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...
ykrishnay
565
views
ykrishnay
asked
Sep 6, 2022
Databases
databases
self-doubt
database-design
rdbms
+
–
2
votes
1
answer
3
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 in A is related to exactly one tuple of B. Each tuple of A is related to zero or more tuple of B. None of these.
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...
LRU
324
views
LRU
asked
Sep 28, 2021
Databases
database-design
test-series
relational-model
+
–
0
votes
0
answers
4
UGC NET CSE | December 2005 | Part 2 | Question: 18
In a relational schema, each tuple is divided in fields called : Relations Domains Queries All the above
In a relational schema, each tuple is divided in fields called :RelationsDomainsQueriesAll the above
go_editor
241
views
go_editor
asked
Mar 27, 2020
Databases
ugcnetcse-dec2005-paper2
databases
database-design
+
–
1
votes
2
answers
5
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 ________ memory spaces and $B$ has _______ memory spaces. $20,20$ $3,20$ $3,4$ $20,4$
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...
go_editor
1.2k
views
go_editor
asked
Mar 24, 2020
Databases
ugcnetjan2017ii
databases
database-design
+
–
0
votes
1
answer
6
DBMS Korth Edition 6 Exercise 7 Question 29 (Page No. 321)
Explain the distinction between total and partial constraints.
Explain the distinction between total and partial constraints.
ajaysoni1924
827
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
0
votes
1
answer
7
DBMS Korth Edition 6 Exercise 7 Question 28 (Page No. 321)
Explain the distinction between disjoint and overlapping constraints.
Explain the distinction between disjoint and overlapping constraints.
ajaysoni1924
848
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
2
votes
0
answers
8
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.
Explain the distinction between condition-defined and user-defined constraints.Which of these constraints can the system check automatically?Explain your answer.
ajaysoni1924
553
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
5
votes
0
answers
9
DBMS Korth Edition 6 Exercise 7 Question 26 (Page No. 321)
Design a generalization-specialization hierarchy for a motor vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attributes at each level of the hierarchy. Explain why they should not be placed at a higher or lower level.
Design a generalization-specialization hierarchy for a motor vehicle salescompany. The company sells motorcycles, passenger cars, vans, and buses.Justify your placement o...
ajaysoni1924
2.0k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
2
votes
0
answers
10
DBMS Korth Edition 6 Exercise 7 Question 23 (Page No. 320)
Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. Your design ... , a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
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...
ajaysoni1924
843
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
0
votes
0
answers
11
DBMS Korth Edition 6 Exercise 7 Question 22 (Page No. 319-320)
Design a database for a worldwide package delivery company (e.g., DHL or FedEx). The database must be able to keep track of customers (who ship items) and customers (who receive items); some customers may do both. ... E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
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...
ajaysoni1924
1.6k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
er-diagram
database-design
+
–
4
votes
0
answers
12
DBMS Korth Edition 6 Exercise 7 Question 21 (Page No. 319)
Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is identified by a vehicle ... , a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
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...
ajaysoni1924
1.5k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
4
votes
0
answers
13
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 discs and downloadable videos to its collection. ... model the case where a shopping basket may contain any combination of books, Blu-ray discs, or downloadable video.
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...
ajaysoni1924
3.0k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
1
votes
0
answers
14
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 adding appropriate attributes. Why, then, do we have weak entity sets?
We can convert any weak entity set to a strong entity set by simply addingappropriate attributes. Why, then, do we have weak entity sets?
ajaysoni1924
435
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
0
votes
1
answer
15
DBMS Korth Edition 6 Exercise 7 Question 18 (Page No. 319)
Explain the difference between a weak and a strong entity set.
Explain the difference between a weak and a strong entity set.
ajaysoni1924
441
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
–1
votes
1
answer
16
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 of medical doctors. Associate with each patient a log of the various tests and examinations conducted.
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...
ajaysoni1924
738
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
2
votes
2
answers
17
DBMS Korth Edition 6 Exercise 7 Question 14 (Page No. 318)
Explain the distinctions among the terms primary key, candidate key, and superkey.
Explain the distinctions among the terms primary key, candidate key, andsuperkey.
ajaysoni1924
1.5k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
2
votes
1
answer
18
DBMS Korth Edition 6 Exercise 7 Question 13 (Page No. 318)
Temporal changes: An E-R diagram usually models the state of an enterprise at a point in time. Suppose we wish to track temporal changes, that is, changes to data over time. For example, Zhang may have been a student between ... , with the above extensions to track temporal changes. b. Convert the above E-R diagram into a set of relations.
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...
ajaysoni1924
629
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
1
votes
0
answers
19
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 higher-level entity sets X and Y. Discuss how to handle a case where an attribute of X has the same name as some attribute of Y.
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...
ajaysoni1924
537
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
0
votes
0
answers
20
DBMS Korth Edition 6 Exercise 7 Question 11 (Page No. 317)
In SQL, foreign key constraints can only reference the primary key attributes of the referenced relation, or other attributes declared to be a super key using the unique constraint. As a result, total participation constraints on a ... 4.4.7 of korth). (Unfortunately, these features are not supported on any widely used database currently.)
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...
ajaysoni1924
767
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
4
votes
0
answers
21
DBMS Korth Edition 6 Exercise 7 Question 10 (Page No. 317)
Consider a many-to-one relationship R between entity sets A and B. Suppose the relation created from R is combined with the relation created from A. In SQL, attributes participating in a foreign key constraint can be null. Explain how a constraint on total participation of A in R can be enforced using not null constraints in SQL.
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...
ajaysoni1924
669
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
0
votes
0
answers
22
DBMS Korth Edition 6 Exercise 7 Question 9 (Page No. 317)
Suppose the advisor relationship was one-to-one. What extra constraints are required on the relation advisor to ensure that the one-to-one cardinality constraint is enforced?
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...
ajaysoni1924
322
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
0
votes
0
answers
23
DBMS Korth Edition 6 Exercise 7 Question 8 (Page No. 317)
Consider a relation such as sec_course, generated from a many-to-one relationship sec_course. Do the primary and foreign key constraints created on the relation enforce the many-to-one cardinality constraint? Explain why.
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...
ajaysoni1924
284
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
descriptive
+
–
2
votes
0
answers
24
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 to its attributes the primary-key attributes of its identifying entity set. Outline what sort of redundancy will result if we do so.
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...
ajaysoni1924
1.1k
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
database-design
er-diagram
descriptive
+
–
0
votes
0
answers
25
DBMS Korth Edition 6 Exercise 7 Question 6 (Page No. 316-317)
Consider the representation of a ternary relationship using binary relationships as described in this book and illustrated in Figure (b) (attributes not shown) a. Show a simple instance of E, A, B,C, RA, RB, and RC that cannot correspond ... for E. Show how to treat E as a weak entity set so that a primary-key attribute is not required.
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...
ajaysoni1924
581
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
1
votes
0
answers
26
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 in terms of the structure of an enterprise schema? a. The graph is disconnected. b. The graph has a cycle.
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...
ajaysoni1924
564
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
1
votes
0
answers
27
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 allowing this redundancy a bad practice that one should avoid?
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...
ajaysoni1924
386
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
0
votes
0
answers
28
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 favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. ... . b)Extend the E-R diagram of above exercise to track the same information for all teams in a league.
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...
ajaysoni1924
940
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
0
votes
0
answers
29
DBMS Korth Edition 6 Exercise 7 Question 2 (Page No. 315)
Consider a database used to record the marks that students get in different exams of different course offerings (sections). a. Construct an E-R diagram that models exams as entities, and uses a ternary relationship, for the ... a particular student and section pair, yet you can represent the marks that a student gets in different exams.
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...
ajaysoni1924
374
views
ajaysoni1924
asked
Mar 28, 2019
Databases
databases
korth-edition6
database-design
er-diagram
+
–
Page:
1
2
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register