SY ey UNIVERSITY EXAMINATION 2022/2023 SCHOOL OF COMPUTING AND INFORMATICS DEPARTMENT OF INFORMATION TECHNOLOGY /ENTERPRISE, COMPUTING cIT/DIT/DBIT REGULAR UNIT CODE: DIT1101/CIT1104 UNIT TITLE: INTRODUCTION TO DATABASE DATE: NOVEMBER, 2022 ‘MAIN EXAM TIME: 2 HOURS PATE: NOVEMBER, 2022 MAINEXAM TIME: 2 HOURS. INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO. QUESTION ONE ) Define the following terms; 4) Datum, ii) Database constraint. iii) Data mart. iv) Tuple. ¥) Cardinality. (5 Marks) b) Explain the purposes of the THREE DBMS languages. (6 Marks) ‘¢) Describe the following terms giving a valid example in each case; ) Entity ii) Attribute 4) Relationship (6 Marks) ©) Explain any FOUR differences between file-based system and database management system. (6 Marks) Paper One Page 1we a) v) Entity relationship model (12 Marks) QUESTION THREE student_i | first nam |second nam [Cours [Gende |KCS | County a e e e r E 125 James Salam BCOM |Male [C+ Kiambu 126 ‘Ann Kamau DIT__[Male[C _| Wajir 127 Kelvin Mutiso BCOM | Female | A’ Garissa 128 Sheila’ Omondi BBIT | Male B Nairobi 129 James Amboso BIT Female | C+ Turkana 130 Kelvin Omondi BCOM | Male A Bungoma a Paper One Page 2 4) Highlight any FIVE functions of a database administrator. QUESTION TWO 8) Using the following diagram, answer questions that follow; i) Provide the relational schema for the ERD given above. ii) Identify and explain the following types of attributes from the ERD above; a) Key attribute b) Derived attribute c) Multi-valued attribute (5 Marks) (6 Marks) (6 Marks) b) Using diagrams, explain the following type of database models: i) Network database model ii) Flat database model iii) Relational database model iv) Hierarchical database modela bi Wangui Dir ]Male [C acta 8) Using the above table, use SQL statements to answer the following questions. ‘The table name is thL_students and the database name is college, Hence, ‘using SQL statements perform the following tasks; '} Create database college. (1 Mark) ii) Create table tbl students. (2 Marks) iii) Show/extract all the data or records from the table tbl_students. ss (2 Marks) ® in) Select column Student_ID, Course and gender from tbl_students. (1 Mark ¥) Select all students from table where Course is DIT and KCSE is C. (@ Marks) vi) Sort all the students by descending order of County. (1 Mark) vii) Delete student Purity from the table. (1 Mark) vill) Delete all records from table tbl students (2 Marks) b) Explain the THREE level architecture of a database management system (internal, conceptual and external}. Draw a diagram for illustration. (8 Marks) QUESTION FOUR @ 4) Describe the database development life cycle (7 Marks) b) In brief, explain the importance of the following objects as used in a database ‘management system; i) Table ii) Query ) Form iv) Report v) Relationship (5 Marks) ©) The type of data to be used in a database must be clearly defined for the purpose of manipulation and storage. For example, ifa field is to be used for calculations, it must be defined with a particular data type. a Paper One Tareee ee a CS a Mount Kenya “~~ University UNIVERSITY EXAMINATION 2017/2018 SCHOOL OF COMPUTING AND INFORMATICS DEPARTMENT OF INFORMATION TECHNOLOGY ~ DIPLOMA/CERTIFICATE IN INFORMATION TECHNOLOGY REGULAR UNIT TITLE: INTRODUCTION TO DATABASE UNIT CODE: DIT 101/C1T1 104 HOURS DATE: JULY, 2018 (MAIN EXAM ™ INSTRUCTIONS: ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS QUESTION ONE 1a) What do the following terms mean in database. (8 Marks) i. Database fi, Field Name fil. Normalization Co iv. DBMS b) Relative database programs are said to be object oriented, name the major five objects found in Ms Access. (6 Marks) ) Using examples, Explain the difference between a validation rule and a validation text. (4 Marks) d) List and explain four application areas where Ms Access is used. (4 Marks) €) Stored data may be destroyed by accident, machine malfunction or otherwise. What are the measures that can be taken to make sure that unauthorized Persons cannot access the database? (4 Marks) ee Paper one Pagetf) Stal te And Explai lai in THREE Types Of Dbms Classified Based On Data Moet (6 Marks) 's contain two QUESTION Two foment tables will 8) A relation: al A celaonal databaee cred. reed deal advertisement: ‘elated the tables are customer and advertis the following fields. Customer table Advertisement table Customerid Advertid Name Content Address DateAdvertPlaced NoOfNights Customertype Classification Customerld Customerld and Adi fastens a ‘Advertid are the primary ke! tables respectively. What is a relational database? (2 Marks) ‘etween primary and foreign Key fields (4 Marks) ‘a foreign key field in a table, (4 Marks) y fields for the customer and i Distinguish be it .e roles of a primary and iii, Explain th Name the attribute which is the foreign key in the advertisement table- (2 Marks) e attributes. What is an (2 Marks) iv. sn customeriD and Nam .d in a database. are created Of with respect t ig it use data storage. Indexes (g Marks) ve index and why a) Explain the meaning of the following terms pata redundancy ii, Data consistency iii, Data intesrit, iv. Data independenceze QUESTION THrEe a Sete the he eso rpc Ss seces. omar) » Acre MY fort reper at cm bot was ping hes (ears) i ay Explain the importance ofa primary ky tn a tate, Chey oottte QUESTION Four 1 SO ed be = eae Op y Write Short Notes On The Following Database Languages: (marks) oe 0 ont oat ol So we P) Outline Five Limitations OFA File-Based System 5 marks) or eee od yen aoe ©) Using The Notations For ER Diagrams, Draw An E-R Diagram For A College 9% o Database Schema With St structural Constraints Specified Using (hin, Max) Notations And Role Names. The Database Consists Of Three Entities (Lecturer, Student And Subject). Include At Least Attributes For Every Entity. QUESTION FIVE eae: oot 2) Explain the following terms as used in DBMS. (10 Marks) ‘o! 4. Data Consistency o i. Integrity ¢ fii, Data independence j fv. Data Sharing 1 v. Views: ) Define the term Cardinality and illustrate any four types of cardinality using 7 diagrams. (10 Marks) Paper one Page 3paper > ‘ ——_— eeeoreregess Paper One