• 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

    All the properties of these above components were set using the object inspector below: Debugging Function - When there was a syntax error I used the debugging facility to help me fix the error. The Access tables which I used were the: Members Table (Design View) Films Table (Design View)

  2. Computing Project

    15/03/2008 18:00:00 21347418 36 Burleigh Road, Loughborough, LE115DS Katy Buckland 15/03/2008 15:30:00 21547854 32 Oxford Road, Cambridge, CM115KP Lyne Payne 14/03/2008 14:15:00 22174895 6 Stewart Drive, Manchester, MN148SK Richard Talver 14/03/2008 08:00:00 22531484 78 Kerrysdale avenue, Rushden, NN83LB Anne Smith 14/03/2008 16:45:00 23597854 21 Albert road, Leeds, LD128FF John Smith

  1. Computing Module 3 Writeup

    This produces a message box, which displays the error. The validate value starts off True. If any of the validation criterion are breached, then this validate value is made False and this value is taken up into CmdAddCen Public Sub and this stops the database from being updated, as it will only be updated if Validate=True.

  2. Smart Card System

    Qualified providers are signed by a trusted entity.) JCE 1.2.1 supplements the JavaTM 2 platform, which already includes interfaces and implementations of digital signatures and message digests. This release of JCE is a non-commercial reference implementation that demonstrates a working example of the JCE 1.2.1 APIs. A reference implementation is similar to a proof-of-concept implementation of an API specification.

  1. Creating a computer system for Wooten Basset Rugby Club

    2.8 Macro Design I have designed a macro that allows the user to preview or print a report from the reports menu. Each option in an option box is assigned to a report and when combined with clicking on either the print or preview button the corresponding action takes place.

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

    newer software and hardware as well as the inconvenience of setting the system up. The installation process could take a fair amount of time and disrupt customer relations, which are such a high principle to the company's success. The solution would involve updating the string techniques for customer data.

  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