Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 2 - A relation that contains no multivalued attributes and has non - key attributes solely dependent on the primary key but contains transitive

12-A relation that contains no multivalued attributes and has non-key attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?
a) first
b) second
c) third
d) fourth
e) none of them
13- When all multivalued attributes have been removed from a relation, it is said to be in:
a) first normal form
b) second normal form
c) Boyce-Codd normal form
d) third normal form
e) none of them
14-All of the following are the main goals of normalization except:
a) minimize data redundancy
b) maximize storage space
c) simplify the enforcement of referential integrity
d) make it easier to maintain data
e) increase manageability
15- A constraint between two attributes is called a(n):
a) functional relation
b) attribute dependency
c) functional dependency
d) functional relation constraint
e) none of them
16- A candidate key must satisfy all of the following conditions except:
a) the key must uniquely identify the row.
b) the key must indicate the row's position in the table.
c) the key must be nonredundant.
d) each non-key attribute is functionally dependent upon it.
e) all of them should be satisfied
17- The attribute on the left-hand side of the arrow in a functional dependency is:
a) determinant
b) candidate key
c) foreign key
d) primary key
e) none of them
18- What does the following query return from the database?
select c__id from section as S where semester = 'Fall' and year =2009 and not exists (select * from section as T where semester = 'Spring' and year =2010 and S.c_id = T.c_id);
a) all courses taught in Spring 2010 but not in Fall 2009
b) all courses taught in both Fall 2010 and Spring 2009
c) all courses taught in both Fall 2009 and Spring 2010
d) all courses taught in Fall 2009 but not in Spring 2010
e) none of them
19- SQL applies predicates in clause after groups are formed, so aggregate functions may be used.
a) group by
b) with
c) where
d) from
e) having
3
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Structured Search For Big Data From Keywords To Key-objects

Authors: Mikhail Gilula

1st Edition

012804652X, 9780128046524

More Books

Students also viewed these Databases questions

Question

Explain the purposes of managing performance.

Answered: 1 week ago

Question

List 4 methods to evaluate training.

Answered: 1 week ago