Nigeria's free digital learning hub. Videos, lecture notes, practice questions and leaderboards aligned with CCMAS, NBTE, NCCE, WAEC, NECO, IJMB and JAMB curricula.
Loading
Nigeria's free digital learning hub. Videos, lecture notes, practice questions and leaderboards aligned with CCMAS, NBTE, NCCE, WAEC, NECO, IJMB and JAMB curricula.
This is the complete lecture note for LIS 421 Database Design and Management. You can read it online below, open it in the full viewer, or download the PDF for offline study. It pairs with the course's video lectures, so you can read and watch together.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS • Course code: LIS 421 • Course title: Database Design and Management • Credit load: 2 Units (Lecture Hours 15; Practical Hours 45) • Series list: 1. Concepts and Foundations of Database Design and Management 2. Types of Databases and Principles for Microcomputers 3. Applications of Databases in Library and Information Fields 4. Processes of Database Design, Creation, and Maintenance 5. Advanced Database Systems and Practical Management Proposed Outline for Series 1 • Part 1.1 Key Concepts in Database Design and Management • 1.1.1 Definition of data • 1.1.2 Definition of database • 1.1.3 Definition of database design • 1.1.4 Definition of database management • Part 1.2 Scope of Database Design and Management • 1.2.1 Scope of database design • 1.2.2 Scope of database management • 1.2.3 Importance of database principles for microcomputers • Part 1.3 Principles of Database Systems • 1.3.1 Relational database systems • 1.3.2 Database principles for microcomputers • Introduction • Databases are at the heart of modern information systems, and understanding their foundations is essential for anyone studying library and information science. In this first Series, we will explore the basic concepts that underpin database design and management. You will encounter definitions of key terms such as data, database, database design, and database management, and you will see how these concepts form the building blocks of more advanced topics. • The aim of this Series is to provide you with a clear grounding in the principles of database systems, particularly relational databases, and to explain the scope of database design and management. By beginning here, you will be able to appreciate how databases
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS are structured, why they are important, and how they support the work of libraries and information centres. • We will start by defining the core concepts, then move on to examine the scope of database design and management, and finally consider the principles of database systems with emphasis on relational models and microcomputer applications. This sequential approach ensures that you build a strong foundation before progressing to more complex aspects of database design and management in later Series. Series Learning Outcomes By the end of Series 1: Foundations of Database Design and Management, you should be able to: • SLO 1.1 Define the key concepts of data, database, database design, and database management. • SLO 1.2 Explain the scope of database design and database management in relation to information systems. • SLO 1.3 Analyse the importance of database principles for microcomputers, with emphasis on relational database systems. • SLO 1.4 Evaluate how foundational concepts and principles support later stages of database development and applications. 1.1 Key Concepts in Database Design and Management Databases are built upon a set of fundamental ideas that guide their design and use. In this Part, we will define the core concepts that form the foundation of database design and management. 1.1.1 Definition of Data Data refers to raw facts, figures, or symbols that represent information. Data can be numbers, text, images, or sounds. On its own, data has little meaning until it is organised and processed. Fill in the blank: • Raw facts, figures, or symbols that represent information are called __________.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS 1.1.2 Definition of Database A database is an organised collection of data that can be easily accessed, managed, and updated. Databases are designed to store information systematically so that users can retrieve and manipulate it efficiently. Fill in the blank: • An organised collection of data that can be accessed and updated is called a __________.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS 1.1.3 Definition of Database Design Database design is the process of structuring a database to meet specific requirements. It involves deciding how data will be stored, organised, and related to ensure efficiency and accuracy. Fill in the blank: • The process of structuring a database to meet specific requirements is called __________.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS 1.1.4 Definition of Database Management Database management refers to the activities involved in controlling and maintaining a database system. It includes tasks such as updating records, ensuring data security, and managing user access. Fill in the blank: • The activities involved in controlling and maintaining a database system are called __________.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS Pilot questions 1.1 1. Define data. 2. What is a database? 3. What does database design involve? 4. List two functions of database management. 5. Fill in the blank: An organised collection of data that can be accessed and updated is called a __________. 1.2 Scope of Database Design and Management
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS The scope of database design and management refers to the range of activities, responsibilities, and applications that these processes cover. It helps us understand not only what databases are, but also how they are planned, implemented, and maintained in different contexts. 1.2.1 Scope of Database Design Database design involves determining how data will be structured, stored, and related. Its scope includes: • Identifying user requirements. • Defining data types and relationships. • Designing tables, fields, and keys. • Ensuring efficiency, accuracy, and scalability. Fill in the blank: • The process of determining how data will be structured, stored, and related is called __________.
This is the opening of the note. Read the full note or download the PDF to continue.
