Oladapo Kayode Abiodun

Course Title: Database Design and Management

Course Code: CMP 309

Introduction

Database design management is a three-credit course first semester. It is a compulsory course for all computer science, software engineering and cyber security in the department of physical and computer sciences who need to acquire the basic skills in the area of database design and management. This course focuses on information storage, retrieval, management, capturing and representation. It is a course where students will be exposed to Database management systems and basic concepts. The functions and components of DEMS’ file design. The use of database query language. In the process of completing the course, students are expected to go through the sections on the lecturer’s page and read each section carefully as well as participate in activities and evaluations. It is also important the students should open and read through all the links provided in each section by clicking on them. The students should also read the recommended textbooks and other materials.

Course Aim

The aim of this course is to introduce students to the basic knowledge of database design and management. This will entail a thorough idea of the application of database management systems which are important factors for computing professionals. This course offers the student the opportunity of the study of information storage, retrieval, capture and representation. A good knowledge of this course content will guide the student in the process of database design and management.

Course Outline

Information Storage and Retrieval, Information Management Application, Information Capture and Representation, Analysis and Indexing, Search, Retrieval, Information Privacy, Integrity, Scalability, Efficiency and Effectiveness. Database Management Systems, Review of Basic Concepts, Function and Components of DBMS, File Design and Access Path: Future Direction in DBMS, Use of Database query language

Course Objectives

After completing the course successfully, the student should be able to:

1. Explain information storage and retrieval
2. Explain the Information management application
3. Explain Information capture and representation
4. Discuss analysis and indexing
5. Define the basic concepts of database, database design and database management
6. List and explain the importance and features of databases
7. Identify and explain the types and categories of databases
8. Discuss the function and components of DBMS
9. Explain the file design and access path
10. Discuss the use of database query language
11. Discuss the future direction of DBMS
12. Conduct and carry out a research paper in relation to the course.

Assessment

• Class Attendance, Participation and Discussion: 5 marks
• Course Research Paper: 20 marks
• Mid-Semester: 5 marks
• Final: 70 marks

Information about the instructor

• Instructor: Kayode Oladapo
• Education: Ph. D. in Computer Science
• Email: oladapoka@mcu.edu.ng

Main Course

• Week 1: Introductory Class
• Week 2: Information Storage and Retrieval
• Week 3 - 4: Information Management Application
• Week 5: Information Capture and Representation,
• Week 6 - 7: Analysis and Indexing, Search, Retrieval, Information Privacy, Integrity, Scalability, Efficiency and Effectiveness.
• Week 8: Course Research Paper / Mid Semester Test
• Week 9- 10: Database Management Systems,
• Week 11 – 12: Review of Basic Concepts, Functions and Components of DBMS,
• Week 13 – 14: File Design and Access Path: Future Direction in DBMS
• Week 15 - 16: Use of Database query language
• Week 17: Revision
• Week 18 - 19: Examination

Week 1: Introductory Class

• Course Link
• Introduction
• Course Outline
• Discussion
  • Data
  • Data Processing
  • Information
  • Value of Information
  • Computer and Computer System
  • Computer Networks
• Reading Materials

Week 2: Information Storage and Retrieval

Click to access the Week Two Slide

• Computers and data processing techniques have made possible the high-speed, selective retrieval of large amounts of information from various quarters.
• The term information storage and retrieval indicates the system used for organizing knowledge for subject retrieval.
• information storage and retrieval, the systematic process of collecting and classifying data so that they can be located and displayed on request.
• Information retrieval is the process of recovering a specific piece of information from stored data
• There are several basic types of information storage and retrieval systems. Document-retrieval systems store entire documents, which are usually retrieved by title or by keywords associated with the document. In some systems, the text of documents is stored as data. This permits full-text searching, enabling retrieval on the basis of any words in the document. In others, a digitized image of the document is stored, usually on a write-once optical disc. Database systems store the information as a series of discrete records that are, in turn, divided into discrete fields (e.g., name, address, and phone number); records can be searched and retrieved on the basis of the content of the fields (e.g., all people who have a particular telephone area code). The data are stored within the computer, either in main storage or auxiliary storage, for ready access. The storage of information, once only on the hard drives of computers with large processing capacity, now takes place in a unique way, so that it is possible to access files, data, and applications anywhere and anytime, using either a computer or mobile devices, provided there is an Internet connection, through storage in the so-called “clouds”.

Information Retrieval Process

Any information storage and retrieval system will have a complex series of operations before documentary information can be used:

1. Information must be recorded in documents;
2. Each document must be stored with others in some accessible place and its location known;
3. Characteristic aspects of each document profile, and this must be recorded with others in the same file;
4. The potential user must formulate some query or express some interest in terms of characteristics recorded about documents;
5. This user profile must be compared with document profiles and the locations of matching documents identified;
6. The documents must be located and presented to the user

Information Retrieval System

Week 3 - 4: Information Management Application

• Information Management Application Lecture Slide
• Lecture Outline
  • Introduction to information management
  • Features of an Information management application
  • Information lifecycle management
  • Processes of information lifecycle management
  • Why is information management important?
  • How does information management relate to database design and management?
  • Applying information management principles to database design and management
• Lecture Activities
  • Discussion
    • Data Security
    • Why do we need data models

Week 5: Information Capture and Representation

• Click Here for Week 5 Lecture Slide

• Lecture Activities

  • Group Task
    • Library Management System:
      • Design a database to manage books, borrowers, and transactions in a library system. Include features for checking in/out, searching for books, and managing overdue fines.
    • E-commerce Platform
      • Create a database for an e-commerce website, covering product catalog, customer information, order processing, and inventory management.
    • Hospital Management System:
      • Design a database for a hospital, including patient records, doctor schedules, and billing information. Consider relationships between patients, doctors, and appointments.
    • Social Media Platform:
      • Develop a database schema for a social media platform, including user profiles, friend connections, posts, comments, and likes.
    • Online Banking System:
      • Design a database for an online banking system, covering user accounts, transactions, and account history. Implement security measures for sensitive information.
    • Student Information System:
      • Create a database to manage student records, class schedules, grades, and attendance for an educational institution.
    • Travel Booking System:
      • Design a database for a travel agency, including customer information, reservations, and travel itineraries. Consider different types of travel services like flights, hotels, and car rentals.
    • Inventory Management System:
      • Develop a database to track inventory for a retail business. Include product details, stock levels, and order processing.
    • Event Management System:
      • Design a database to manage events, including information on attendees, schedules, venues, and ticket sales.
    • Employee Management System:
      • Create a database for employee records, payroll, and performance evaluations. Consider relationships between employees, departments, and positions.
  • Real Estate Management System:
    • Design a database for a real estate company, covering property listings, client information, and sales transactions.
  • Issue Tracking System:
    • Develop a database for tracking issues and bugs in software development projects. Include features for issue assignment, status tracking, and resolution.
  • Fitness Tracking App Database:
    • Design a database for a fitness-tracking application, including user profiles, workout logs, and progress tracking.
  • Recipe Management System:
    • Create a database for managing recipes, including ingredients, cooking instructions, and user ratings.
  • Online Learning Platform:
    • Design a database for an online learning platform, covering courses, instructors, students, and course enrollment.

Week 1: Week 9 - 12

• Click Here for Week 9 - 12 Lecture Slide

Week 1: Week 13 - 16

• Click Here for Week 13 - 16 Lecture Slide

Assignment Submission

Name:


Email:


Upload your file:


Message: