OPPapers.com

Database Analysis And Database Design Project

TABLE OF CONTENTS

TABLE OF CONTENTS 2

ASSIGNMENT 3

INTRODUCTION 6

REQUIREMENTS OF THE NEW SYSTEM 6

ADVANTAGES OF COMPUTER BASED SYSTEM 7

MOVING IMAGES DATABASE DESIGN 8

ENTITY RELATIONSHIP DIAGRAMS – CONCEPTUAL MODEL 8

ENTITY RELATIONSHIP DIAGRAM – LOGICAL MODEL 9

DATABASE SCHEME 10

MOVING IMAGES DATA DICTIONARY 13

IMPLEMENTATION 16

RELATIONSHIP BETWEEN THE TABLES 22

PROTOTYPES OF USER INTERFACE 23

VERIFYING AND EVALUATING MY DESIGN 25

MOVING IMAGES 25

TESTING BUTTONS 26

TESTING THE QUERIES 29

TESTING REPORTS 34

REPORT BASED ON QUERIES 37

EVALUATION 42


ASSIGNMENT

Moving Images operates a DVD library.   The library has a large number of titles, each title having at least one copy.   Each title falls into a specific category some of these are adventure, thriller, fantasy, action or education.   (There are others)

All titles are loan only to registered members of Moving Images.   Information is keep about the members is only personal details including name, address and contact number.

Any titles overdue incur a surcharge of 50% of the loan fee.

As an employee of a software company, you are required to design a Relational Database for Moving Images.   The client requires that information is stored so that they can maintain details of all of their DVD's, they wish to track loaned titles and check on overdue titles.   They also require the facility to produce ad-hoc reports.

You need to use appropriate Data Analysis and Database Design Techniques to structure your data and build the database system.   Notes must be made in all stages of the process from Analysis through to Implementation and Testing.

Learning Outcomes

Students will be able to:

1. Design Small Databases
1.1 Apply data analysis and design techniques for a given context
1.2 Verify that a design meets user requirements
1.3 Use appropriate software to document designs

2. Implement and use Databases
2.1 Use a variety...