Database Design And Management

1. Define database concepts and terminology.
2. Design and implement relational databases using SQL.
3. Apply normalization techniques to database design.
4. Manage database transactions and ensure data integrity.
5. Describe web-based information systems and their applications.
6. Discuss the challenges of database development and management in libraries.

13 weeks, about 32 hours in total. Yours will differ.

1. Week 1Module 1: Concept, Importance, and Characteristics of Databases

   • Unit 1: Definition of Concepts; Importance and Characteristics of Databases · 2 hours

     Read the introduction to understand the concept of databases.. Study the definition of data, information, and knowledge.. Understand the importance of databases in libraries and information centers.. Review the characteristics, advantages, and disadvantages of database management systems..

2. Week 2Module 1: Concept, Importance, and Characteristics of Databases

   • Unit 2: Types and categories of Databases · 2 hours

     Identify and describe the different types of databases.. Study the characteristics of centralized, distributed, and cloud databases.. Understand the differences between general-purpose and subject-specific databases.. Explore operational and analytical databases..

3. Week 3Module 1: Concept, Importance, and Characteristics of Databases

   • Unit 3: Database design, development, maintenance, and Implementation strategies · 2 hours

     Learn about the phases of database design, including data collection, strategy, and implementation.. Study the System Development Life Cycle (SDLC) and its stages.. Understand the Database Life Cycle (DBLC) and its components.. Explore top-down and bottom-up database design approaches..

4. Week 4Module 2: SQL, Modelling, and Normalisation

   • Unit 1: SQL, and Data Modelling · 2 hours

     Define Structured Query Language (SQL) and its role in database management.. Study SQL Data Definition Language (DDL) commands: CREATE, ALTER, DROP, and TRUNCATE.. Understand data retrieval, maintenance, and control in SQL..

5. Week 5Module 2: SQL, Modelling, and Normalisation

   • Unit 2: Normalization 1NF, 2NF, 3NF · 2 hours

     Define database normalization and its goals.. Study the first three normal forms: 1NF, 2NF, and 3NF.. Understand the processes involved in achieving each normal form..

6. Week 6Module 2: SQL, Modelling, and Normalisation

   • Unit 3: Storage Management of databases · 2 hours

     Define storage management in databases.. Study the attributes of storage management: capacity, performance, recoverability, and reliability.. Understand the types of storage devices: main memory, secondary storage, and tertiary storage..

7. Week 7Module 3: Transaction management and relational database systems

   • Unit 1: Transaction Management and Query Evaluation of Databases · 2 hours

     Define transaction and transaction management.. Study the ACID properties of transactions: Atomicity, Consistency, Isolation, and Durability.. Understand the transaction model and possible outcomes: commit and rollback..

8. Week 8Module 3: Transaction management and relational database systems

   • Unit 2: Distributed and Non-distributed Database Systems. · 2 hours

     Define distributed and non-distributed databases.. Study the advantages and disadvantages of distributed databases.. Understand the types of distributed database systems: homogeneous and heterogeneous.. Explore distributed database architecture and strategies..

9. Week 9Module 4: Network-centric, Web-based Systems

   • Unit 1: Network-centric Data Management · 2 hours

     Define network-centric data management.. Study the network-centricity software development framework.. Understand the characteristics of a network-centric environment.. Explore the challenges of network-centricity..

10. Week 10Module 4: Network-centric, Web-based Systems

    • Unit 2: Web-based Information Systems · 2 hours

      Define web-based information systems.. Study the evolution of web-based information systems.. Understand the criteria for measuring the quality of web-based information systems: reliability, usability, security, availability, scalability, and maintainability..

11. Week 11Module 5: Heterogeneous, Information Integration and Data Management

    • Unit 1: Heterogeneous databases; · 2 hours

      Define heterogeneous databases.. Study the characteristics of heterogeneous databases.. Understand the requirements for heterogeneous database integration.. Explore query models and approaches to communication in a heterogeneous environment..

    • Unit 2: Information integration and Wireless Data Management; · 2 hours

      Define information integration and wireless data management.. Study the requirements for information integration.. Understand the architecture of information integration.. Explore workflow messaging and activities process integration..

12. Week 12Module 6: Competencies, Challenges, and Practicum in Database Management

    • Unit1: Basic skills and competencies of the database manager and user; · 2 hours

      Define a database manager and a database user.. Study the skills and competencies of a database manager.. Understand the duties and responsibilities of a database manager.. Explore the types of database users..

    • Unit 2: Challenges of development and Management of database in libraries and information centres in Nigeria. · 2 hours

      Study the challenges of developing and managing databases in libraries and information centers in Nigeria.. Understand the technical infrastructure requirements.. Explore issues related to building digital collections, metadata, and data security..

13. Week 13Module 6: Competencies, Challenges, and Practicum in Database Management

    • Unit 3: Practicum in building and maintaining databases in libraries and information centres. · 4 hours

      Review all units and modules.. Work on assignments and TMAs.. Prepare for final examinations..