Login Create Account

Back to Course Catalog

LIS318Education2 Unitsintermediate

Database Design And Management

This course introduces students to database design and management, focusing on the design, implementation, management, and application of Database Management Systems. Students will gain basic knowledge of database design and management, concepts, and techniques necessary to understand and implement the relational database model. Topics include SQL, Data Modelling, normalization, storage management, transaction management, query evaluation, web-based information systems, and challenges in libraries and information centers.

Take a Practice Test Generate AI Study Notes

Take a practice test or generate AI study notes to help you excel in this course.

50h

Study Time

13

Weeks

4h

Per Week

basic

Math Level

Course Keywords

Database DesignSQLData ModelingNormalizationData Management

Course Overview

Everything you need to know about this course

Course Difficulty

Intermediate Level

Builds on foundational knowledge

65%

intermediate

➕

Math Level

Basic Math

🔬

Learning Type

Hands-on Practice

Course Topics

Key areas covered in this course

1

Database Concepts

2

SQL

3

Data Modeling

4

Normalization

5

Transaction Management

6

Web-based Systems

7

Heterogeneous Databases

Total Topics7 topics

Ready to Start

No specific requirements needed

This course is designed to be accessible to all students. You can start immediately without any prior knowledge or specific preparation.

Assessment Methods

How your progress will be evaluated (3 methods)

Assignments

Comprehensive evaluation of course material understanding

Written Assessment

Tutor-Marked Assessments

Comprehensive evaluation of course material understanding

Written Assessment

Final Examination

Comprehensive evaluation of course material understanding

Written Assessment

Career Opportunities

Explore the career paths this course opens up for you

Database Administrator

Apply your skills in this growing field

Data Analyst

Apply your skills in this growing field

Database Developer

Apply your skills in this growing field

Information Architect

Apply your skills in this growing field

Data Manager

Apply your skills in this growing field

Industry Applications

Real-world sectors where you can apply your knowledge

LibrariesInformation CentersE-commerceHealthcareFinance

Study Schedule Beta

A structured 13-week journey through the course content

Week

1

Module 1: Concept, Importance, and Characteristics of Databases

2h

Unit 1: Definition of Concepts; Importance and Characteristics of Databases

2 study 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.

Week

2

Module 1: Concept, Importance, and Characteristics of Databases

2h

Unit 2: Types and categories of Databases

2 study 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.

Week

3

Module 1: Concept, Importance, and Characteristics of Databases

2h

Unit 3: Database design, development, maintenance, and Implementation strategies

2 study 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.

Week

4

Module 2: SQL, Modelling, and Normalisation

2h

Unit 1: SQL, and Data Modelling

2 study 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.

Week

5

Module 2: SQL, Modelling, and Normalisation

2h

Unit 2: Normalization 1NF, 2NF, 3NF

2 study 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.

Week

6

Module 2: SQL, Modelling, and Normalisation

2h

Unit 3: Storage Management of databases

2 study 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.

Week

7

Module 3: Transaction management and relational database systems

2h

Unit 1: Transaction Management and Query Evaluation of Databases

2 study 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.

Week

8

Module 3: Transaction management and relational database systems

2h

Unit 2: Distributed and Non-distributed Database Systems.

2 study 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.

Week

9

Module 4: Network-centric, Web-based Systems

2h

Unit 1: Network-centric Data Management

2 study 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.

Week

10

Module 4: Network-centric, Web-based Systems

2h

Unit 2: Web-based Information Systems

2 study 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.

Week

11

Module 5: Heterogeneous, Information Integration and Data Management

4h

Unit 1: Heterogeneous databases;

2 study 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 study 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.

Week

12

Module 6: Competencies, Challenges, and Practicum in Database Management

4h

Unit1: Basic skills and competencies of the database manager and user;

2 study 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 study 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.

Week

13

Module 6: Competencies, Challenges, and Practicum in Database Management

4h

Unit 3: Practicum in building and maintaining databases in libraries and information centres.

4 study hours

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

This study schedule is in beta and may not be accurate. Please use it as a guide and consult the course outline for the most accurate information.

Course PDF Material

Read the complete course material as provided by NOUN.

Access PDF Material

Study Tips & Exam Preparation

Expert tips to help you succeed in this course

1

Review all module summaries and key terms.

2

Practice SQL queries and normalization exercises.

3

Create concept maps linking transaction management principles.

4

Focus on understanding the differences between database types.

5

Study case studies on database implementation in libraries.

6

Practice past exam questions to identify areas of weakness.

Related Courses

Other courses in Education that complement your learning

Management of Digital/Virtual Libraries for Writing

Methods of Teaching Reading in Primary Schools

Motor Learning And Human Performance

View All Education Courses