• 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

Video Rental System

Extracts from this document...


Final Project Report Video Rental System Objective: Business Rules: � A store can have one or more employees. � An employee may or may not manages one store. � A employee may or may not have one or more employee job history. � A employee is assigned an user id for login. � An user id associated with one and only one employee. � A employee may or may not creates one or more customers. � A customer can be created by one and only one employee. � A employee may or may not change one or more rental item types. � A rental item type can be changed by one and only one employee. � A rental item type may or may not have one or more rental items. � A rental item can be of one and only one rental item type. � A vendor may or may not placed one or more purchase orders. � A Purchase order can contains one or more Purchase order detail lines. � A Customer rental table resolves the many to many relationships between the Customer and Rental item table. � A rental item may or may not be rented by one or more customers. � A customer may or may not rent one or more rental items. � And Customer rental history table also resolves the many to many relationships between the Customer and Rental item. ...read more.


Y STORE_ADDRESS2 Store Address Text 100 X(100) STORE_CITY Store City Text 100 X(100) Y STORE_STATE Store State Text 2 X(2) Y STORE_ZIP Store Zipcode Text 11 X(11) Y STORE_PHONE Store Phone Text 12 X(12) Y STORE_FAX Store FAX Text 12 X(12) STORE_MANAGER Store Manager Number Long Int 0-99999999 USER USER_ID User ID Autonumber Long Int 1-99999999 Y PK USER_LOGIN_ID User Login ID Text 255 X(255) USER_PWD User Password Text 255 X(255) USER_CREATED_DATE User Created Date Date/Time dd/mm/yyyy hr:min:sec am/pm USER_LAST_LOGIN User Last Login Date/Time dd/mm/yyyy hr:min:sec am/pm EMP_ID Employee ID Number Long Int 1-99999999 FK EMPLOYEE IS_ADMIN Employee is Admin or not Yes/No VENDOR VEND_ID Vendor ID Autonumber Long Int 1-99999999 Y PK VEND_NAME Vendor Name Text 255 X(255) Y VEND_CFNAME Vendor First Name Text 100 X(100) Y VEND_CLNAME Vendor Last name Text 100 X(100) Y VEND_ADDRESS1 Vendor Address Text 255 X(255) Y VEND_ADDRESS2 Vendor Address Text 255 X(255) VEND_CITY Vendor City Text 100 X(100) Y VEND_STATE Vendor State Text 2 X(2) Y VEND_ZIP Vendor Zipcode Text 11 X(11) Y VEND_PHONE Vendor Phone Text 12 X(12) Y VEND_FAX Vendor Fax Text 12 X(12) Normalization: Before Normalization the "CUSTOMER" table contained the "RENTAL RETURN DATE" AND "ITEM RENT PAY". Since the Customer can rent more than one item this caused data anomalies. There were multiple entries for one customer. Note: All the table attributes are not included for the ease of description. The required and important attributes are used to show the normalization. ...read more.


[ITEM_RUNTIME] as VideoRunTime,[ITEM_LANG] as VideoLanguage, [ITEM_RATING] as VideoRating,[ITEM_RELEASE_DATE] as VideoReleaseDate, [ITEM_TOTAL_STOCK] as TotalStock,[ITEM_CURRENT_STOCK] as CurrentStock, [ITEM_TYPE_DESC] as RentalItemType FROM (RENTAL_ITEM INNER JOIN RENTAL_ITEM_TYPE ON RENTAL_ITEM.ITEM_TYPE_ID=RENTAL_ITEM_TYPE.ITEM_TYPE_ID) Insert insert into [rental_item] (item_name,item_short_desc,item_long_desc, item_type_id,item_runtime,item_lang,item_rating,ITEM_RELEASE_DATE,created_date) values (@nme,@sdesc,@ldesc,@itype,@runtime,@lng,@rating,@rdate,@dte) @nme @sdesc @ldesc @itype @runtime @lng @rating @rdate @dte Update: update [rental_item] set item_name=@nme,item_short_desc=@sdesc,item_long_desc=@ldesc, item_release_date=@rdate,item_rating=@rating, item_runtime=@runtime, item_lang=@lng where [item_id]=@itid @nme @sdesc @ldesc @rdate @rating @runtime @lng @itid Purchase order Select SELECT PURCHASE_ORDER.PUR_ORDER_ID AS Id, PURCHASE_ORDER.PUR_ORDER_DATE as OrderDate,VENDOR.VEND_NAME as VendorName,PURCHASE_ORDER.PUR_RECEIVED as Received, PURCHASE_ORDER.PUR_RECEIVED_DATE as ReceivedDate FROM (PURCHASE_ORDER INNER JOIN VENDOR ON PURCHASE_ORDER.VEND_ID = VENDOR.VEND_ID) Select purchase order detail for a given purchase order SELECT PURCHASE_ORDER_DETAIL.PUR_ORDER_DETAIL_ID as LineNo, RENTAL_ITEM.ITEM_NAME as ItemName, PURCHASE_ORDER_DETAIL.ITEM_QTY as Qty FROM (PURCHASE_ORDER_DETAIL INNER JOIN RENTAL_ITEM ON PURCHASE_ORDER_DETAIL.ITEM_ID = RENTAL_ITEM.ITEM_ID) where PURCHASE_ORDER_DETAIL.PUR_ORDER_ID = @poid order by PURCHASE_ORDER_DETAIL.PUR_ORDER_DETAIL_ID insert purchase order insert into [purchase_order] (pur_order_date,vend_id)" values (@pdate,@vend_id) @pdate @vend_id select max(pur_order_id) as maxid from purchase_order"; insert into [purchase_order_detail] pur_order_id,pur_order_detail_id, item_id,item_qty) values (@poId,@pdId,@itemId,@qty) @poId @pdId @itemId @qty Receive purchase order update [purchase_order] set [pur_received]=@rec,[pur_received_date]=@recdate where pur_order_id=@pid @rec @recdate @pid" select [item_total_stock],[item_current_stock] from rental_item where item_id=@itemid update [rental_item] set [item_current_stock]=@cStock ,[item_total_stock]=@tStock where item_id=@itemid"; @cStock @tStock @itemid Purchase order Reports SELECT VENDOR.VEND_NAME as VendorName, po.PUR_ORDER_DATE as PODate FROM (PURCHASE_ORDER po INNER JOIN VENDOR ON po.VEND_ID = VENDOR.VEND_ID) where po.pur_order_date between #{@stdate}# and #{@endate}#" @stdate @endate customer rental report SELECT CUSTOMER.CUS_FNAME as CustomerFirstName, CUSTOMER.CUS_LNAME as CustomerLastName, CUSTOMER_RENTAL.RENTAL_DATE as RentalDate, RENTAL_ITEM.ITEM_NAME as ItemName, RENTAL_ITEM_TYPE.ITEM_TYPE_DESC as ItemDescription FROM (((CUSTOMER_RENTAL INNER JOIN CUSTOMER ON CUSTOMER_RENTAL.CUS_ID = CUSTOMER.CUS_ID) INNER JOIN RENTAL_ITEM ON CUSTOMER_RENTAL.ITEM_ID = RENTAL_ITEM.ITEM_ID) INNER JOIN RENTAL_ITEM_TYPE ON RENTAL_ITEM.ITEM_TYPE_ID = RENTAL_ITEM_TYPE.ITEM_TYPE_ID) where CUSTOMER_RENTAL.RENTAL_DATE between #{@stdate}# and #{@endate}#", @stdate @endate ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Computing Project

    11457848 Sean Higgins 125 Buckingham Avenue, Bath, BA15SS 0015 8794649 12147894 Harry Atkinson 32A Church Street, Manchester, MA326TR 0248 6497466 21347418 Katy Buckland 36 Burleigh Road, Loughborough, LE115DS 0150 9296797 21547854 Lyne Payne 32 Oxford Road, Cambridge, CM115KP 0117 3526594 22174895 Richard Talver 6 Stewart Drive, Manchester, MN148SK 0178 2649849

  2. Computing Module 3 Writeup

    The validation checking loop starts off at the top. So, if no value had been entered for Centre Number, a message box would pop up displaying the error. Once this has been rectified and the validation rule passes, validate gets reset to True and the loop continues.

  1. Smart Card System

    The Java 2 platform already has implementations and interfaces for digital signatures and message digests. JCE 1.2 was created to extend the Java Cryptography Architecture (JCA) APIs available in the Java 2 platform to include APIs and implementations for cryptographic services that were subjected to U.S.

  2. Computing Project

    Name Data Type Length Validation Example Data Comment Film Title The Matrix The name of the DVD Film Genre String 20 Characters Max Must only Contain letters Horror The genre of the film Length String 5 Characters 01.30 How long the film lasts for Age Certificate 2 Characters Must only

  1. Creating a computer system for Wooten Basset Rugby Club

    qrySeason The season query will extract all the scores of all the fixtures from the entire season. The attributes involved will be: FixtureCode, TeamCode, TournamentCode, TeamScore, RivalScore,Date, Home/Away, andWinner. 6. qryOrganiserAway This query will find all the fixture taking place between the actual day it is being used and a week later.

  2. Definition-nature of the problem solved - Car Mechanic business

    Solution 1- with the owner feeling that the current system is still fairly efficient it maybe most effective to make subtle changes to this original system so as not to alienate employees unfamiliar with more complex methods. Remaining with the paper based system saves the need for large investments in

  1. White Soul System Designs - creating a computer system.

    Also a lot of the time customers are not carrying any item that may prove their identity or are not carrying a letter to prove their address. No members may be added to the files with out first proving their identity and address so they have to return home to

  2. Machine Shack Management System.

    The owner Mr Robertson currently runs it and is starting to find it increasingly hard to manage sales, due to increasing number of customers. Since business is running well he has decided to invest in a computer system to help run business more smoothly and give a better service to his customers.

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