• 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

    ON [Members Table].MemberId = [Loans Table].MemberID WHERE ((([Loans Table].DateBack)<Date())); This query was used to gather a list of all the loans which are overdue. This is present on the Overdue Loans Form below on this ADO Query component. 4. Sample of detailed Algorithm Design Setting Up Username and Password procedure TFMSetupUserandPass.BtnSaveClick(Sender: TObject); begin//begin if//if (EdUsername.text='')

  2. Computing Project

    the program is tested, every statement is executed, accuracy of the processing and that the program fits the original specification. This will make sure that the system is running correctly as this is basically using the whole system. I am also going to test the system in a beta testing method, although this will be a small scale.

  1. Smart Card System

    The "Java Cryptography Architecture" (JCA) refers to the framework for accessing and developing cryptographic functionality for the Java Platform. It encompasses the parts of the JDK 1.1 Java Security API related to cryptography (currently, nearly the entire API), as well as a set of conventions and specifications provided in this document.

  2. Creating a computer system for Wooten Basset Rugby Club

    However this query only generates this data for away matches. 7. qryOrganiserHome This query is exactly the same as the one above however it extracts data for home match. A home match will not require the same data as an away match so less data is needed such as direction to another's team venue.

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

    manager and all his employees are fully aware of the security measures that have to be in place. * While a small amount of customisation is possible, a database application contains far less than a spreadsheet or word application making it harder to accurately represent the company logo and colour schemes.

  2. Computing Module 3 Writeup

    Unload Me End Sub Private Sub Form_Load() datCentre.Recordset.AddNew End Sub Public Function Validate() As Boolean Validate = True If (txtCentreNo.Text = "") Then MsgBox ("Centre number has to be entered") Validate = False Exit Function End If If txtCentreNo.Text < 10000 Then MsgBox ("Centre number must be between 10000 and 79999")

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

    If a customer wants to use this discount their file must be found. One of the members of staff will look in the filing cabinet for the customers file. All customers' records are stored in alphabetical order in our files.

  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