[go: up one dir, main page]
Scribd
Upload
6 views2 pages

Project Database Application

The document outlines a project for operating a database application focused on pharmacy-related data. It includes tasks such as creating a database, tables for pharmacists, drugs, and sales, establishing relationships, entering records, creating data entry forms, using queries, and generating reports. Each task has specific instructions to guide the user through the database management process.

Uploaded by

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

Project Database Application

The document outlines a project for operating a database application focused on pharmacy-related data. It includes tasks such as creating a database, tables for pharmacists, drugs, and sales, establishing relationships, entering records, creating data entry forms, using queries, and generating reports. Each task has specific instructions to guide the user through the database management process.

Uploaded by

yabtes186
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

ROYAL COLLEGE Sub-Sector :ICT : Project : ODBA

Project information tools, equipment and information, you are expected to


performance the following projects.
Project 3: Operate Database Application
Instruction: under this project you are expected to operate database Application by performing
the following seven tasks based on the information provided.

Task 1: create a database

Instruction: under this task you are expected to create a database called pharmacy.

Task 2: create tables

Instruction: under this task you are expected to create called table.

Pharmacist

Field Data type Properties


PID Text Primary key
Name Text
Sex Text Field size =1
Must accept only M or F
Qualification Text

Drug

Field Data type Properties


PID Text Primary key
DName Text
Procedure Text
Production Date Date/Time
Expire Date Date/Time Input mask of short date

Sales

Field Data type Properties


SID Text Primary key
PID Text
DID Text
SALES DATE Text Input mask of short date
Task 3: create Relationship

Instruction: Under this task you are expected to appropriate relationships between the table

Task 4: Enter record into table

Instruction: Under this task you are expected to insert the following date into the three tables

Task 5: create data entry form

Instruction: Under this task you are expected to create data entry form for the sales table.

Task 6: record data using data entry form

Instruction: Under this task you are expected to enter the following date using the form you
create in task five.

SID PID Sales Date


S005 P001 08/08/2016
S006 P003 08/08/2016

Task 7: use query

Instruction: Under this task you are expected to enter the following activities based on the
information provider:-

 Create query that selects DName, Producer,and production Date of drugs with name the
starts with letter A.
 Update the producer to Addis and expire date to 03/03/2018 ot a record with SID values
of S004 in the drug table.
 Create a query that accepts an SID as parameter to delete record form sales table.

Task 8: Create report

Instruction: Under this task you are expected to create a report that shows the Name,
DName, Producer and Sales Date for all sales.

You might also like