Access over 20 million homework & study documents

Green highlighted optionsare

Content type
User Generated
Type
Study Guide
Rating
Showing Page:
1/4
IS582 Week 2 test preparation
Green highlighted options are Correct
1. The purpose of the database is to
a.help people keep track of things
b.store data in tables
c. maintain data on different things in different tables
d.create tables of rows and columns
e.allow web applications to retrieve data
2.Referential intergrity constraints are used to limit the possible values of a
a.candidate key
b.surrogate key
c.foregin key
d.composite key
e. dependency
1. In a sql query which built in function is used to compute the no. of rows in a table
a) Avg
b) Count
c) Max
d) Min
e) Mean
1. A sales contact manger application used by a salesperson is an example of an
……………………

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/4
a.single user database application
b.multi user database application
c. e-commerce database application
all of the above
both A or C
1. Saying that two entities are functionally dependent means that ……………….
a) Entities are always connected by a mathematical equation
b) For one of the entities if we are given the value of that entity we can determine the value of
one other entity
c) For both of the entities if we are given the value of those entities we can determine the
value of one other entity
d) The functional dependency will have to be removed through normalization
e) All of the above
1. Match the following terms to their definitions
Answer potential matches
min 1. Sql built in function that obtains the smallest value in a numeric column
max 2. Sql built in function that obtains the largest value in a numeric column
count 3. Sql built in function that computes the number of rows in a table
sum 4. Sql built in function that totals values in a numeric column
Avg_ 5. SQL built in function that computes the average of values in a numeric column
1. Explain the relationships among the primary keys and functional dependencies. (20
points)

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/4

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 4 pages?
Access Now
Unformatted Attachment Preview
IS582 Week 2 test preparation Green highlighted options are Correct 1. The purpose of the database is to a.help people keep track of things b.store data in tables c. maintain data on different things in different tables d.create tables of rows and columns e.allow web applications to retrieve data   2.Referential intergrity constraints are used to limit the possible values of a a.candidate key b.surrogate key c.foregin key d.composite key e. dependency   1. In a sql query which built in function is used to compute the no. of rows in a table a) Avg b) Count c) Max d) Min e) Mean   1. A sales contact manger application used by a salesperson is an example of an …………………… a.single user database application b.multi user database application c. e-commerce database application all of the above both A or C   1. Saying that two entities are functionally dependent means that ………………. a) Entities are always connected by a mathematical equation b) For one of the entities if we are given the value of that entity we can determine the value of one other entity c) For both of the entities if we are given the value of those entities we can determine the valu ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents