July 7, 2021 in C and CPP
1.1 Which of the following is the correct order of evaluation for the below expression?
z = x + y * z / 4 % 2 - 1
A) * / % + - =
B) = * / % + -
C) / * % - + =
D) * % / - + =July 7, 2021 in C and CPP
b) Discuss the role of high level data model in the database design process.July 7, 2021 in C and CPP
a) A college contains many departments. Each department can offer any number of courses. Many instructors can work in a department. An instructor can work only in one department. For each department there is a Head. An instructor can be head of only one department. Each instructor can take any number of courses. A course can be taken by only one instructor. A student can enroll for any number of courses. Each course can have any number of students.
Draw an ER diagram for this schema that takes into account all the assertions given.July 7, 2021 in C and CPP
c) How privileges are granted and revoked in a secured database? Explain with example.July 7, 2021 in C and CPP
b) What is a checkpoint and when does it occur?July 7, 2021 in C and CPP
a) Differentiate between Deferred database modification and immediate database modification.July 7, 2021 in C and CPP
c) A relation ADDRESS is defined as follows.
ADDRESS(Name, Street, City, State, Postal_code)
Where name is unique, and for any given postal code, there is just one city and state.
i) Give a set of FDs for this relation.
ii) Is ADDRESS in 3NF or 2NF? Explain why? If it is not in 3NF, normalize it into 3NF
relations.July 7, 2021 in C and CPP
b) Given the following relational instance,
A B C
1 2 3
3 1 2
1 1 2
4 1 5
Which of the following functional dependencies are satisfied?
i) AB->C
ii) C->A
iii) AC->BJuly 7, 2021 in C and CPP
a) Consider the following set of functional dependencies for a relation R(ABCDE):
F= {AB->C, CD->E, DE->B}
What is the key of this relation?July 7, 2021 in C and CPP
b) For a relational scheme R(ABCD) find the canonical cover for given set of FD,s.
F= {A->BC, B->C, A->B, AB->C}
