Please answer the following questions explaining proof of answer for credit... 1
ID: 666934 • Letter: P
Question
Please answer the following questions explaining proof of answer for credit...
1.
n2
n
n log n
log n
2. Usually, MANAGER and DEPARTMENT have a _____ relationship (manages/managed by).
3. Suppose that A, B and C are attributes of a certain relational table. Consider the functional dependency A --> B. Then _____.
4. In the following relational schema, the primary key is _____.
PRODUCT (PROD_CODE, PROD_DESCRIPTION, PROD_PRICE, SUP_CODE)
5. Usually, STUDENT and CLASS have a _____ relationship (takes/has).
6. A(n) _____ is a restriction on the data that help to ensure data integrity.
7. One of the components of the ODBC architecture is _____.
Which of the following functions grows at a faster rate than the rest? (Points : 6)Explanation / Answer
1. n^2.
Explanation : growth of rate depends on the power of n. From the options given, n^2 has greatest power.
2. manages
Explanation : manager manages a department. Manager managed by department is wrong, it doesn't make sense.
3. (A,B) -> C
4. PROD_CODE
Explanation : 2 products can have same description as they can be of different brands, same price and can be grouped by SUP_CODE
SO prod_code is the unique attribute to identify a product.
5. takes
Explanation : student cannot has a class, class has students. So, student takes class is correct.
6. referntial integrity constraint(foreign key)
7. Data source