Scribd
Upload
9 views1 page

Database Management Project Guidelines

The document outlines a project for a Database Management course requiring the creation of a database with at least 6 tables, each having a minimum of 7 fields. It includes specifications for data validation, relationships, data entry forms, queries, a bar chart, reports, and macros. Additionally, it instructs the deletion of records and the inclusion of group member information.

Uploaded by

iAmHannibal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views1 page

Database Management Project Guidelines

The document outlines a project for a Database Management course requiring the creation of a database with at least 6 tables, each having a minimum of 7 fields. It includes specifications for data validation, relationships, data entry forms, queries, a bar chart, reports, and macros. Additionally, it instructs the deletion of records and the inclusion of group member information.

Uploaded by

iAmHannibal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

KMTC

COMPUTER APPLICATIONS II PROJECT

DATABASE MANAGEMENT

1. Create the prescribed database according to your groups.


2. Create at least 6 tables for the database (you can have more).
3. Each table should have a minimum of 7 fields with corresponding
datatypes.
NB: Restrict the data as much as possible i.e make use of validation
rules, validation texts, input masks, etc). Pick what is appropriate for
your datatype,
4. Create appropriate relationships between the existing tables and
enforce referential integrity.
5. The primary table should have at least 50 records (you can have
more).
6. All data involving currency should be converted to KES.
7. Design a form for data entry in each of the tables.
8. Define and create at least 4 queries retrieving data from at least 5
tables. Be very specific with the queries.
9. Create a bar chart for the data.
10. Create 3 reports of your choice, calculated and grouped.
11. Create the following macros.
a. Open a table of your choice
b. Open a report of your choice
c. Open a form
d. Automate and calculation
e. Apply filters
f. Trigger an action when a record is added
g. Close the database
12. Use the form created to delete any 6 records from the primary
table.
13. Add a table with names and college numbers of group
members

You might also like