MGT268MasterDataTransactionData (1)

MGT268MasterDataTransactionData (1) - Number Double *TID...

Info iconThis preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon
BP's Data Enterprise Systems Database and its data constrains what can be entered into the system.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data In ERP Systems Configuration Data Master Data Transaction Data
Background image of page 2
Configuration Data Makes the ERP work for individual company Defines Business Rules for a company Generally done once when system is installed Time consuming
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Master Data vs Transaction Data Master Data: About people or things Entered First Usually accurate (becomes so over time) Doesn’t Change Much Transaction Data: About Events Entered after associated Master Data Refers to Master Data Short Lived More prone to errors
Background image of page 4
Referential Integrity Not necessarily right for P2
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Player Team HRuns *PID Text 6 Last Text 15 First Text 10 DOB Date Short *TID Text 5 Name Text 15 City Text 12 SSize
Background image of page 10
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 14
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Number Double *TID *PID * Year Date Year HRuns Number Integer Video Customer Rental *VID t 5 Title t 35 Length N double Acquisition Date *CID t 6 Lname t 15 Fname t 10 Phone t 12 *VID t 5 *CID t 6 *Date d short Product Order Header Customer Order Detail *PID t 19 Description t 25 Price currency *CID t 10 Name t 25 Zip t 5 *OID t 8 Date d short Left out:- Product Total *OID *PID Qty Master Data vs Transaction Data Master Data: About people or things Entered First Usually accurate Doesnt Change Much Transaction Data: About Events Entered after associated Master Data Refers to Master Data Short Lived More prone to errors Referential Integrity Not necessarily right for P2...
View Full Document

This note was uploaded on 05/25/2011 for the course MGT 268 taught by Professor Paragkosalge during the Spring '08 term at Grand Valley State University.

Page1 / 14

MGT268MasterDataTransactionData (1) - Number Double *TID...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online