<=Back
<=KNEC Diploma in ICT module 2 Database Management System past paper: November 2021
The following is a database schema. Use it to answer the questions that follows
STUDENT (STUDENTID, STUDENTNAME);
COURSE (COURSEID, COURSENAME);
LECTURER (LECTURERID, LECTURENAME);
• A student is assigned a course
• A lecturer delivers a course
• A student can be assigned many courses
• A lecturer can deliver only one course
Draw an entity relationship diagram (ERD) for the database
STUDENT (STUDENTID, STUDENTNAME);
COURSE (COURSEID, COURSENAME);
LECTURER (LECTURERID, LECTURENAME);
• A student is assigned a course
• A lecturer delivers a course
• A student can be assigned many courses
• A lecturer can deliver only one course
Draw an entity relationship diagram (ERD) for the database
Viewed: 40 times
For Better experience and learning,for video answers, after video ends playing, click next question in the questions list!!!
Share in:
Questions List:
1. Outline four roles of a database architect
2. Texan bank uses a file based approach in its operations. Outline four limitations of this approach
3. Describe three components of a database
4. With aid of a diagram describe the client-server database management system
5. Define each of the following terms as used in database management system; (4 marks) i) entity; (ii) attributes.
6. Chema SACCO intends to undertake requirement gathering for its database. Explain three types of requirements that could be gathered
7. With aid of a diagram describe the network database model
8. Explain each of the following terms as used in cloud computing database technology: (i) standardization (ii) Virtualization (ii) Automation
9. Define each of the following terms as used in databases. (i) Schema (ii) Tuple (iii) Relaxation
10. Outline four characteristics of a relational database domain.
11. Distinguish between degree and a cardinality as used in relational databases
12. Patrand added constraints to a relational database during a practical lesson. Explain three constraints she could have added
13. Explain each of the following terms as used in databases. (i) data independence; (ii) Database instance
14. With aid of a diagram in each case, distinguish between two-tier and three-tier database architectures
15. Explain each of the following phase of a database development life cycle: (i) requirement analysis (II) conceptual database design; (iv) Logical database design.
16. Table 2 shows the attributes used to create a relation named TAXPAYER. Use it to answer the questions that follows
17. Outline four advantages of using entity relationship diagram
18. Outline three differences between strong and weak entities as used in database modelling
19. Explain each of the following terms as used in entity relationship diagram: (I) Candidate key; (ii) Derived attributes
20. The following is a database schema. Use it to answer the questions that follows STUDENT (STUDENTID, STUDENTNAME); COURSE (COURSEID, COURSENAME); LECTURER (LECTURERID, LECTURENAME); • A student is assigned a course • A lecturer delivers a course • A student can be assigned many courses • A lecturer can deliver only one course Draw an entity relationship diagram
21. Outline four properties of a relationship in First Normal Form(INF).
22. Explain each of the following terms as used in databases. (i) Decomposition (ii) Update Anomaly
23. Differentiate between functional and trivial dependencies as used in normalization
24. Distinguish between schedule and serializability as used in database transactions
25. Drake, a database administrator, has been tasked with implementing concurrency in the company database system. Outline five benefits of this control
26. With the aid of a Venn diagram, explain the intersection operation as used in relational algebra
27. John a system administrator, created an account for a user. Explain two privileges that the user may be granted
28. A student has been asked to analyse the process of transaction execution in a database. Explain each of the following database transaction states that may have analysed: (i) atomicity; (ii) Consistency;
29. With the aid of an SQL statement in each case, Explain the following commands: (i) Insert; ii)Select.
30. The following datatypes were used in a database tables. Describe each of the data types. (i) Float; ii) Varchar; (iii) Text
1. Outline four roles of a database architect
2. Texan bank uses a file based approach in its operations. Outline four limitations of this approach
3. Describe three components of a database
4. With aid of a diagram describe the client-server database management system
5. Define each of the following terms as used in database management system; (4 marks) i) entity; (ii) attributes.
6. Chema SACCO intends to undertake requirement gathering for its database. Explain three types of requirements that could be gathered
7. With aid of a diagram describe the network database model
8. Explain each of the following terms as used in cloud computing database technology: (i) standardization (ii) Virtualization (ii) Automation
9. Define each of the following terms as used in databases. (i) Schema (ii) Tuple (iii) Relaxation
10. Outline four characteristics of a relational database domain.
11. Distinguish between degree and a cardinality as used in relational databases
12. Patrand added constraints to a relational database during a practical lesson. Explain three constraints she could have added
13. Explain each of the following terms as used in databases. (i) data independence; (ii) Database instance
14. With aid of a diagram in each case, distinguish between two-tier and three-tier database architectures
15. Explain each of the following phase of a database development life cycle: (i) requirement analysis (II) conceptual database design; (iv) Logical database design.
16. Table 2 shows the attributes used to create a relation named TAXPAYER. Use it to answer the questions that follows
17. Outline four advantages of using entity relationship diagram
18. Outline three differences between strong and weak entities as used in database modelling
19. Explain each of the following terms as used in entity relationship diagram: (I) Candidate key; (ii) Derived attributes
20. The following is a database schema. Use it to answer the questions that follows STUDENT (STUDENTID, STUDENTNAME); COURSE (COURSEID, COURSENAME); LECTURER (LECTURERID, LECTURENAME); • A student is assigned a course • A lecturer delivers a course • A student can be assigned many courses • A lecturer can deliver only one course Draw an entity relationship diagram
21. Outline four properties of a relationship in First Normal Form(INF).
22. Explain each of the following terms as used in databases. (i) Decomposition (ii) Update Anomaly
23. Differentiate between functional and trivial dependencies as used in normalization
24. Distinguish between schedule and serializability as used in database transactions
25. Drake, a database administrator, has been tasked with implementing concurrency in the company database system. Outline five benefits of this control
26. With the aid of a Venn diagram, explain the intersection operation as used in relational algebra
27. John a system administrator, created an account for a user. Explain two privileges that the user may be granted
28. A student has been asked to analyse the process of transaction execution in a database. Explain each of the following database transaction states that may have analysed: (i) atomicity; (ii) Consistency;
29. With the aid of an SQL statement in each case, Explain the following commands: (i) Insert; ii)Select.
30. The following datatypes were used in a database tables. Describe each of the data types. (i) Float; ii) Varchar; (iii) Text
