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

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

Extracts from this document...


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.


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.


> 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. GCSE Database Project ICT

    After each session, the dentist writes in the top left corner what date the patient should return, as the patient visits more times the corner looks very scruffy. Another problem the secretary faces is when appointment renewals have to be made.

  1. ICT Project 1A

    I thought that I needed to change my homepage because it was too informal and needed to include a bit more information about the band. Here is what I replaced it with. Another change that I made was to the Bill and Tom page.


    Boundaries The Processing would be: * Calculating the grades through a Vlookup to the grade boundaries table. * Sorting, grouping and summarising data with a pivot table. * Calculate the average of total marks * Using Vlookup work out a grade for the average.

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

    rent the same movie at the same time and rentals will be rejected. This stops any overbooking rentals and prevents any unnecessary problems. The system will be much more efficient and faster than the old data storage systems as any details could be located in a matter of seconds rather than minutes.

  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.

    DELETING THE BOOK FROM THE DATABASE- it is sometimes essential to delete a book from the record because of anonymous reasons. This can only be done by a librarian only. 6. TRAINING STAFF- on the addition of new librarians or employees in the library, it is essential for them

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