1 / 5

GB Video Dimensional Example

GB Video Dimensional Example. Customer #Cust No F Name L Name Ads1 Ads2 City State Zip Tel No CC No Expire. Requestor of. Rental #Rental No Date Clerk No Pay Type CC No Expire CC Approval. Line #Line No Due Date Return Date OD charge Pay type. Owner of. Holder of.

keely
Download Presentation

GB Video Dimensional Example

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. GB Video Dimensional Example

  2. Customer #Cust No F Name L Name Ads1 Ads2 City State Zip Tel No CC No Expire Requestor of Rental #Rental No Date Clerk No Pay Type CC No Expire CC Approval Line #Line No Due Date Return Date OD charge Pay type Owner of Holder of Title #Title No Name Vendor No Cost Video #Video No One-day fee Extra days Weekend Name for GB Video E-R Diagram

  3. Line LineID OD Charge OneDayCharge ExtraDaysCharge WeekendCharge DaysReserved DaysOverdue CustID AddressID RentalId VideoID TitleID RentalDateID DueDateID ReturnDateID Customer CustID Cust No F Name L Name Video VideoID Video No Address AddressID Adddress1 Address2 City State Zip AreaCode Phone Title TitleID TitleNo Name Cost Vendor Name Rental Date RentalDateID SQLDate Day Week Quarter Holiday Rental RentalID Rental No Clerk No Store Pay Type Due Date DueDateID SQLDate Day Week Quarter Holiday Return Date ReturnDateID SQLDate Day Week Quarter Holiday GB Video Dimensional Model

  4. Customer #Cust No F Name L Name Ads1 Ads2 City State Zip Tel No CC No Expire Rental #Rental No Date Clerk No Pay Type CC No Expire CC Approval Line #Line No Due Date Return Date OD charge Pay type Video #Video No One-day_ fee Extra_days Weekend Title #Title No Name Vendor No Cost Total sales by month Total amount paid by customer and month Average time videos are kept by customer

  5. Line LineID OD Charge OneDayCharge ExtraDaysCharge WeekendCharge DaysReserved DaysOverdue CustID AddressID RentalId VideoID TitleID RentalDateID DueDateID ReturnDateID Customer CustID Cust No F Name L Name Title TitleID TitleNo Name Cost Vendor Name Rental Date RentalDateID SQLDate Day Week Quarter Holiday Address AddressID Adddress1 Address2 City State Zip AreaCode Phone Return Date ReturnDateID SQLDate Day Week Quarter Holiday Rental RentalID Rental No Clerk No Store Pay Type Due Date DueDateID SQLDate Day Week Quarter Holiday Total sales by month Total amount paid by customer and month Average time videos are kept by customer

More Related