Bilgi Teknolojisi Ödev Yardımı
Bilgi teknolojisi atama yardımı, kullanıcılara en ileri bilim ve teknoloji hakkında çok yüksek kalitede bilgi sağlayabilir. Çok detaylı kategorize edilmiş bilgi verileri vardır ve yazılımın kendisinin bunları kullanma izni yoktur, böylece herkes teknolojiden sonuna kadar yararlanabilir.
Alışılmışın dışında teknoloji ve yaşam için de mükemmel bir içerik organizasyonudur. İlginç ve profesyonel içerik üretmek için kullanıcıları ve markaları birbirine bağlar. Teknik bilgiler, derinlemesine incelemeler, beceri ipuçları ve ürün deneyimleri vb. içerir. Grafik, video ve bilgilendirici reklam içerik formatlarına sahiptir ve başlıca yeni medya platformlarını kapsar.
- Securing a database aims to achieve the following objectives Data Confidentiality Data Integrity Availability Briefly describe what is meant by each of the above objectives. In each name one security controls that can be applied in Database (9marks) ii. Discuss THREE methods of backups used in database (6marks) iii. Discuss FIVE Properties of a Primary Key (5marks)
- QUESTION 11 (20mks) 1. Define the following terms i) Database schema (1 mark) ii) Database Instance (1 mark) iii) Database Management System (1 mark) iv) Relation (1 mark) 2. Explain FOUR ways in how databases can be classified based on number of sites over which Database is Distributed (4marks) 3. Ellaborate any FOUR advantages that database management systems offer in order to overcome the disadvantages of file systems in data storage (4marks) 4. Differentiate between Data Definition Language versus a Data Manipulation Language and use at least one example of each to illustrate your explanation. 5. Explain the following transaction concept. (4 Marks) i. Grant (1 mark) ii. Revoke (1 mark) iii. Commit (1 mark) iv. Rollback (1 mark) (4marks) 6. Explain FOUR benefits of normalizing database containing relations (4marks) 7. Describe any FOUR constraints used in SQL. (4marks) 8. Explain FOUR techniques that are used to perform Database Testing. (4marks) (4marks) 10. Distinguish between a weak entity and a derived entity as used in Entity Relationship diagram (4marks) @2022 The Kenya National Examination Council (Answer any THREE (3)questions in this section). i. A process in a transaction is said to successfully terminate after attaining "acidity". Describe the ACID properties with examples for each state (8marks) 9. Describe the following types of keys as used in database management system i. Primary Key ii. Foreign Key iii. Candidate Key iv. Super Key SECTION B (60 MARKS)
- 10. Define the term database dictionary. 1. Databases consist of several key components that work together to organize, manage, and access data efficiently State FOUR such components. (4 Marks) 2. SQL commands are often categorized based on the type of operation they perform within a database. Outline the FOUR types of these commands. (4 Marks) 3. A good database system is crucial for efficiently managing and storing data , ensuring data integrity and providing reliable and secure access to information. Outline FOUR characteristics one would consider to achieve this. (4 Marks) 4. In the context of a database, differentiate between database schema and database instance. (4 Marks) 5. In SQL, the ALL operator is used in conjunction with certain comparison operators to compare a value with all values in a set. State THREE statements that are usually associated with SQL ALL operator. (3 Marks) 6. Define the term variable in databases. (2 Marks) 7. The database testing process typically involves several key steps to ensure the accuracy, reliability and performance of the database system. Outline the THREE step database test process. (3 Marks) 8. Transaction mechanisms and concurrency mechanisms are essential aspects of database management systems (DBMS) that ensure data consistency and enable efficient multi-user access to the database. Differentiate between transaction mechanisms and concurrency mechanisms. (4 Marks) 9. Derived and stored are examples of data attributes used in a database , Outline TWO differences between the two. (4 Marks) (2 Marks) 11. Normalization is a process in database design that organizes tables and attributes in a database to minimize redundancy and dependency. Outline FOUR advantages of normalization. (4 Marks) 12. In database design,relationships are used between different tables to represent how the data in one table is related to the data in another.State TWO types of database relationships. (2 Marks)
- 1. Define each of the following terms: i.Entity: (2 Marks) ii. Entity type: (2 Marks) iii. Entity set. (2 Marks) 2. State the three levels of data abstraction in Database Management Systems (3 Marks) 3. Describe three keys that can be used in database. (6 Marks) 4. Explain two types of Data Independence in databases. (4 Marks) 5. Explain the term data testing as used in a database. (2 Marks) 6. Explain two reasons for performing database lesting. (3 Marks) 7. Mary developed a database for a company Outline the four key stages she could have followed when testing this database (4 Marks) 8. Mike designed a database using an Entity Relationship Diagram (ERD). Using symbols; describe three connotations of ERD he could use. (6 Marks) 9. There are four most basic operations in database which are the backbone for interacting with database. State two of these database operations. (2 Marks) 10. With the aid of an example in each case, describe three components of a database system. (4 Marks) SECTION B (60 MARKS) Answer any THREE questions from this section. 11. a) Define the term database. (2 Marks) b) Differentiate between field and record as used in databases (2 Marks) c) Explain the following as used in relational database model: (10 Marks) i) Table; ii) Tuple; iii) Attributes; iv) Relation schema; v) Domain. d) Explain the three types of relationships in databases (6 Marks) 12. a) Explain six characteristics of Database Management System. (12 Marks) b) A company has installed a database system for its'operations. Explain four benefits accrued from its use. (8 Marks) 13. a) Data Definition Language is used to bring objects into existence Discuss five database objects. (10 Marks) b) Discuss five types of database security. (10 Marks) 14. a) Highlight four factors considered when choosing the type of database software to adopt. (4 Marks) b) The ACID properties of data transactions provide a mechanism to ensure the correctness and consistency of data in a database. Explain each of these four properties. (8 Marks) c) Databases are designed based on various data models. Discuss four database models.
- f) Exrilain the functions of the following keyboard shortcuts i. CTRL+V ii. CTRL+Lii:CTRL+U (3 marks) E) Highlight the TWO types of booting that can be carried out on a computer (2 Marks)