• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  • Level: GCSE
  • Subject: ICT
  • Word count: 4089

Database Analysis and Database Design Project - DVD library for moving images.

Extracts from this document...

Introduction

DATABASE ANALYSIS AND DATABASE DESIGN PROJECT DVD LIBRARY FOR MOVING IMAGES CARLOS ALBERTO MONTOYA HNC SOFTWARE ENGINEERING (FAST TRACK). LECTURER: SHARON MUNCIE 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. ...read more.

Middle

on the expired date the customer is given 1460 days or three years and the default value is Date()+1460 which means that it is the actual date plus 1460 days. I also got a foreign key (title) this will crate the relationship between the title table and the customers table. One title can be use by many customers DVDs TABLE * DVD_ID * DVD_TITLE * DIRECTOR * ACTOR * CATGEGORY_DESCRIPTION * RATING * PRODUCER * COPIES On the DVDs table I also used autonumber for DVD_ID because it becomes the unique identifier for that DVD and also becomes the primary key for this table. I also have two foreign keys from different tables one foreign key is: category_description from the category table and the other one is rating from the rating table. This two foreign keys will create the relationship between the three tables. One rating can be use by many DVDs and many DVDs can use one category. LOANS TABLE * LOAN_ID * MEMBER_ID * DVD_ID * QUANTITY * PRICE * DATE_OUT * DATE_IN * TOTAL In the loan table I used the autonumber for the loan id which will be unique and because is unique it will become the primary key for this table. The two foreign keys are member's id from members table and DVD id from the DVD table. With this two foreign keys the relationship between the three tables will be possible One member can take many loans and many loads can have one DVD. TITLE TABLE * TITLE This table is only one field (title) and that title being the only one becomes the primary key of that table and the foreign key in the members table to create the relationship. CATEGORY TABLE * CATEGORY_DESCRIPTION This table also has one field (category_description) and being the only one it becomes the primary key on this table and then becomes the foreign key on the DVD table to create the relationship between the two tables. ...read more.

Conclusion

> Edit customer's details This user requirement has been met by creating command button on the main menu call existing member, this command button will then open the manager's login and then the user will be allow to enter to the area where all the information for the customers has been stored and edit any information for an existing customer. > Add new DVDs This user requirement has been met by creating in a very similar way a form on the main menu called new DVDs and it will work in the same way the new member form does. Any new DVD that is enter in to the system will then be save in the DVDs table. > Edit DVDs' details This requirement has been met by creation a command button on the main menu, very similar to the way the user changes members details, a login form will then open and after the user has login the second menu comes up and in there will be a command button called existing DVDs, this will open a form for the user to find any DVD store in the system and changes any information about that DVD. > Rent DVDs (only to register members) When a customer will rent a DVD the customer id must be provide if the customer is not a register customer but a potential customer he would be ask to register with moving images otherwise not DVD would be rented to that person. > Track Loans This could be done through a query (loans query), this will show the user all the information about any DVD that has not been return yet and also will be able to find if any DVD is late for return and how much the surcharge is. The daily surcharge for any DVD that is return late is �1.50. HNC SOFTWARE ENGINEERING 2 CARLOS MONTOYA DATABASE ANALYSIS AND DESIGN ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Hardware & Software Requirements for Database

    more organised, being the results of accurate and faster calculations so the hospital will run and make progress. This hardware is a result of faster calculations for my database which will makes things easier to handle in Whipps Cross Hospital.

  2. ICT PROJECT

    * Protections of cell so that user cannot accidentally delete information. Statement of Input, Processing & Output requirement The input would be: Personal Details: * First name * Surname * Gender * Date of Birth * Form * Roll number Student marks: * Assignment marks Maximum /minimum mark * Grade

  1. This project is designed to help non-computerized library to easily keep track of their ...

    * Provide skillful employ for error free library system SPECIFICATIONS * The librarian should be literate and should know the addition and subtraction very well for the calculation of the stocks of book. * There should be formulas in the system that can be used by the librarian for working out budget calculations.

  2. ICT Report 2b: ICT in Organisations

    It helps the staff because they can receive the store 'news letters' from the manager and it helps suppliers as it allows for deliveries to be made for them. Finally, it helps the customers because they can receive leaflets on the store as a result of the written production under this software.

  1. I will design a new video database for the video shop that will also ...

    This will mean that the end-user should be able to cope with any problems with the system. Priorities for the new system will be the new appointment system, the doctor and patient details, ease of use, and the prevention of data loss.

  2. Database Design Guideline

    I have designed it in the actual database in Microsoft Access, for Whipps Cross Hospital. Doctor ID Forename Surname Address Phone Number Salary Gender Ward Specialist Patient's table: This is how my patient's table will look like when I have designed it in actual database in Microsoft Access; for Whipps Cross Hospital.

  1. Database design.

    Information has meaning and can be used. Databases on computer Databases are put on computers for a number of reasons 1. It is easier to search for a record. 2. There is no unnecessary duplication. 3. You can change delete or print from the database. 4. When you print a report it is tidy and easy to understand.

  2. Computer study project outline - library and book club database.

    SEARCHING THE BOOK- if a person wants see information about a book than he or she can just type the books name and search it. 3. ADDING NEW BOOKS- here not only the librarians but also the teachers and students can add books by typing the information and writing a review on the book.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work