1 / 20

Movie Spot Great movies on the spot

Movie Spot Great movies on the spot. Salini Kokatam Vasavi Bolaram Ashwini Shamirpet Kishore Reddy. Business requirements. The system should allow new user to register, create their profile and buy membership online. Allow customers to rent DVD’s and games

mahola
Download Presentation

Movie Spot Great movies on the spot

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Movie SpotGreat movies on the spot • SaliniKokatam • VasaviBolaram • AshwiniShamirpet • Kishore Reddy

  2. Business requirements • The system should allow new user to register, create their profile and buy membership online. • Allow customers to rent DVD’s and games • Allow customers to renew their membership. • The system should be based on central database system and should be accessed from any computer via internet.

  3. Business Requirements • The website should include facilities like • searching the online catalog, • creating and maintaining customer information, • placing rental orders • The system will enforce rules for processing the data and the principles by which the organization operates. • Rental history is stored & maintained to get information about customers. • Employees should be able to edit customer Information, add daily reports and update Inventory.

  4. Context Diagram

  5. LEVEL 0 DFD

  6. LEVEL 0 DFD

  7. Level1 DFD(Rental Request) • External Entity: Customer • Processes: Search & Request Customer & Employee Processing Validation Shipping • Data Store : D1 Customer Data D3 Rental History D2 Product Details

  8. Level1 DFD(Rental Request) Customer 2.1 Search & Request Movie Name Movie Name D2 Product Details Movie Information Response Request D1 Customer Data Request Message Response 1.0 Customer/Employee Processing Customer Details Register/Renew 2.2 Validation D 3 Rental History Customer Info Product & User ID D2 Product Details Product ID Customer Shipping Address 2.3 Shipping D 3 Rental History Product & User ID Response

  9. Level 2 DFD (Validation) • External Entity: Customer • Processes: Accept User Request Not Member/Membership Expired Rental Limit Validation Data Store : D1 Customer Data D3 Rental History

  10. Level 2 DFD (Validation) 2.2 . 1 Accept User Request 2.2 . 2 Not a member /Membership Expired Request Renew/create Request Details D1 Customer Data Message Customer Info 1.0 Customer/Employee Processing Register/Renew Customer Details Message 2.2 .3 Rental Limit Validation D 3 Rental History Customer Info Product & User ID 2.3 Shipping

  11. Level1 DFD(Return Movie) • External Entity: Customer • Processes: Return Movie Rental Charging Add Product Review • Data Store : D2 Product Details D3 Rental History D4 Product Reviews

  12. Level1 DFD(Return Movie) Customer Update Inventory 3.1 Return Movie Rental D2 Product Details Product Return Confirmation Response Customer, Product Details D3 Rental History Customer Info Response 3.2 Charging Product ID , Cust ID Customer Charge D3 Rental History Number of Days Payment Product Info Product Details & Review 3.3 Add Product Review Req Product Review D4 Product Reviews Response Review

  13. SYSTEM COMPONENTS Processes External Entity ExternalEntity 1.0 Customer/ Employee Processing 2.0 Request Movie CUSTOMER EMPLOYEE 3.0 Return Movie 4.0 Rental History 6.0 Daily Reports 5.0 Update Inventory D1 Customer Data D3 Rental History D5 Employee Data D2 Product Details D4 Product Review D6 Daily Reports Database

  14. Structure Chart

  15. Entity Tables & Attributes Entity: Customers cust_ID cust_username cust_password cust_lname cust_fname cust_street cust_city cust_zip cust_email cust_phone cust_creditcard_num cust_membexp_date Entity: Prod_Review cust_ID prod_ID prod_review Entity: Rental _History cust_ID prod_ID rent_date return_date Entity: Employee emp_ID emp_username emp_password emp_fname emp_lname emp_sex emp_dob emp_street emp_city emp_state emp_zip emp_phone emp_sal Entity: Products prod_ID prod_title prod_lang prod_cost prod_year_rel prod_rating Entity: Daily_Reports emp_ID prod_ID cust_ID checkout_date return_date

  16. ER Diagram

  17. Physical Design Customer (cust_ID, cust_username, cust_password,cust_lname, cust_fname, cust_street, cust_city, cust_zip, cust_email, cust_phone, cust_creditcard_num, cust_membexp_date) Products (prod_ID, prod_title, prod_lang, prod_cost, prod_year_rel, prod_rating)  Prod_Review (cust_ID, prod_ID, prod_review) Online_Transactions (cust_ID, prod_ID, rent_date, return_date) Employee (emp_ID, emp_username, emp_password, emp_fname, emp_lname, emp_sex, emp_dob, emp_street, emp_city, emp_state,emp_zip, emp_phone, emp_sal) Instore_Transactions(emp_ID, prod_ID, cust_ID, checkout_date, return_date)

  18. Implementation in MS Access

  19. Customer Form

  20. ANY QUESTIONS • ????

More Related