Register

Recent questions tagged relational-model

1 votes
0 answers
102
DBMS Korth Edition 6 Exercise 2 Question 4 (Page No. 53)
In the instance of instructor shown below, no two instructors have the same name. From this, can we conclude that name can be used as a superkey (or primary key) of instructor?
In the instance of instructor shown below, no two instructors havethe same name. From this, can we conclude that name can be used as asuperkey (or primary key) of instruc...
User Avatar
1 votes
0 answers
103
DBMS Korth Edition 6 Exercise 2 Question 3 (Page No. 53)
Consider the time slot relation. Given that a particular time slot can meet more than once in a week, explain why day and start time are part of the primary key of this relation, while end time is not.
Consider the time slot relation. Given that a particular time slot can meetmore than once in a week, explain why day and start time are part of theprimary key of this rel...
User Avatar
0 votes
0 answers
105
DBMS Korth Edition 6 Exercise 2 Question 1 (Page No. 53)
Consider the relational database given below . What are the appropriate primary keys? employee (person name, street, city) works (person name, company name, salary) company (company name, city)
Consider the relational database given below . What are the appropriateprimary keys?employee (person name, street, city)works (person name, company name, salary)company ...
User Avatar
0 votes
0 answers
106
DBMS, Made easy practice book
Can primary keys be updated using sql update query? Is such a query accepted/rejected?
Can primary keys be updated using sql update query?Is such a query accepted/rejected?
User Avatar
1 votes
2 answers
107
NIELIT 2018-42
____ symbol is used to denote derived attributes in ER model Dashed ellipse Squared ellipse Ellipse with attribute name underlined Rectangular Box
____ symbol is used to denote derived attributes in ER modelDashed ellipseSquared ellipseEllipse with attribute name underlinedRectangular Box
User Avatar
1 votes
2 answers
108
Made Easy Workbook : Relational Model
What should be correct option for 1. and why...?
What should be correct option for 1. and why...?
User Avatar
0 votes
3 answers
109
relational model
minimum no. of tables required....!!! How to do such question where aggregation generalization or specialization is involved
minimum no. of tables required....!!!How to do such question where aggregation generalization or specialization is involved
User Avatar
0 votes
2 answers
110
ACE Practice book DBMS
Participation Constraints can not be represented for a. Unary relationships b. Binary relationships c. Ternary relationships d. None
Participation Constraints can not be represented fora. Unary relationshipsb. Binary relationshipsc. Ternary relationshipsd. None
User Avatar
6 votes
2 answers
112
ISRO2014-11
An aggregation association is drawn using which symbol? A line which loops back on to the same table A small open diamond at the end of a line connecting two tables A small closed diamond at the end of a line connecting two tables A small closed triangle at the end of a line connecting two tables
An aggregation association is drawn using which symbol?A line which loops back on to the same tableA small open diamond at the end of a line connecting two tablesA small ...
User Avatar
6 votes
1 answer
114
GATE CSE 1992 | Question: 13a
How is redundancy reduced in the following models? Hierarchical Network Relational
How is redundancy reduced in the following models?HierarchicalNetworkRelational
User Avatar
Page: