Database Analysis and Database Design Project

Only available on StudyMode
  • Download(s) : 265
  • Published : March 2, 2008
Open Document
Text Preview
TABLE OF CONTENTS

TABLE OF CONTENTS2

ASSIGNMENT3

INTRODUCTION6

REQUIREMENTS OF THE NEW SYSTEM6

ADVANTAGES OF COMPUTER BASED SYSTEM7

MOVING IMAGES DATABASE DESIGN8

ENTITY RELATIONSHIP DIAGRAMS – CONCEPTUAL MODEL8

ENTITY RELATIONSHIP DIAGRAM – LOGICAL MODEL9

DATABASE SCHEME10

MOVING IMAGES DATA DICTIONARY13

IMPLEMENTATION16

RELATIONSHIP BETWEEN THE TABLES22

PROTOTYPES OF USER INTERFACE23

VERIFYING AND EVALUATING MY DESIGN25

MOVING IMAGES25

TESTING BUTTONS26

TESTING THE QUERIES29

TESTING REPORTS34

REPORT BASED ON QUERIES37

EVALUATION42

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.1Apply data analysis and design techniques for a given context
1.2Verify that a design meets user requirements
1.3Use appropriate software to document designs

2.Implement and use Databases
2.1Use a variety of tools to convert logical designs to physical databases. 2.2Use and maintain data in a relational database system.

Tasks

1.Data Analysis and Database Design

(a)Produce a detailed data requirements specification for Moving Images. (Learning outcome 1.1) The requirement specification should enable you to identify the appropriate entities, relationships between entities and the attributes associated with the entities and relationship types. It must also include the features of the database which are defined as: •Forms that include the ability to add, delete, edit all titles and membership details. •Lists of titles/members according to stated criteria

•Report based on queries.

(b)Produce a short report (Learning outcome 1.2)
•Verify and evaluate that your design matches the requirements of the company and justify how each of the requirements is matched by your design

2.Data Modelling (Learning outcome 1.1 and 1.3)

Build a Conceptual Data Model of the system using Entity Relationship Modelling Techniques and produce the following: •Draw an Entity Relationship Model (ERM) for the system showing cardinality using Chen notation for the above narrative. •Produce a Logical Entity Relationship Model that resolves any cardinality or participation problems in the Conceptual Model •Provide a database schema with detailed design and analysis notes demonstrating how data has been normalised to third normal form. •Produce a Data Dictionary for three related entities showing the name, description, data type, field size, constraint and any default values for each attribute.

3.Implement and use Databases (Learning outcome 2.1 and 2.2)

Using Microsoft Access 97, 2000 or Xp to implement your database you must ensure that your database is robust and able to record information correctly. Validation should be used. The users should find the system easy and attractive to use. They should have the ability to produce ad-hoc queries and print out...
tracking img