Database Planning, Design, And Management
Course Description
Course Description:
The course unit is designed to equip students with the
necessary knowledge to Plan, design and Manage databases in small to medium
enterprises using Ms- Access and MYSQL and it's majorly practical based.
Course Objective:
This course is Objectiveed
at:-
- Training
the learners on how to analyze an Organization’s problems and come up with
a database solution
- Equipping
the student with knowledge to plan, design, implement manage and maintain
medium enterprise databases
- Equipping
the student with the knowledge on how to control access to, manage,
manipulate, data in the database and be able to create reports that will
enable managers to make better decisions
Course Learning
Outcomes:
On successful completion of
this course unit, the students should be able to:
- Identify
the needs of any organization and be able to design a database
- Design
necessary Forms, Reports and Queries for the managers to make the best
decisions
- To
select the best database model for use.
- To
use the Entity Relationship model in Software Development.
- Secure
the database by implementing security measures, integrity rules, and
constraints
- Manage
and maintain an organization’s database