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 maint ...