Get Guided MIS582 Quiz 2

Get Guided MIS582 Quiz 2

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 integrity constraints are used to limit the possible values of a
a.candidate key
b.surrogate key
c.foregin key
d.composite key
e. dependency

3. In a SQL query which built-function is used to compute the no. of rows in a table
Avg
Count
Max
Min
Mean

4. A sales contact manager 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 and C

5. 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

6. Match the following terms to their definitions
Answer potential matches
____________ MAX 1. SQL built-in function that obtains the smallest value in a numeric column
____________SUM 2. SQL built-in function that obtains the largest value in a numeric column
___________ AVG 3. SQL built-in function that computes the number of rows in a table
__________ MIN 4. SQL built-in function that totals values in a numeric column
_________ COUNT 5. SQL built-in function that computes the average of values in a numeric column

7. Explain the relationships among the primary keys and functional dependencies. (20 points)

Want to Buy Quiz?

While you’re at IWantOnlineclasshelp.com then the procedure to rent for an extraordinary degree of offerings may be very easy. To need to do my online examination-associated offerings, you simply need to fill in the shape to be had at the internet site of www.iwantonlineclasshelp.com, and as soon as after carrying out this procedure, all of your facts that carry Order-ID, name, Contact, email address, etc. can be treated through the income professionals for supplying you a few powerful quotations. Once you agree with the great feasible quotation, you want to pay for the offerings, after which the control crew will take higher care of approximately matching pairs of tutors and subjects. We cater to meet all of your desires even Before the closing date with great feasible A or B grades in an assured manner concerning pay someone to take my exam query. You can in reality spend a little amusement time together along with your cherished ones, cope with the distinct priorities you’ve got for your existence, and depart the relaxation to our expert crew. For custom, help email us at [email protected] or WhatsApp us at +1(657)366-7486