Study Guides (248,411)
Canada (121,516)
Administration (1,205)
ADM1370 (82)

Module3_Database Management Systems.docx

6 Pages
39 Views
Unlock Document

Department
Administration
Course
ADM1370
Professor
Craig Kuziemsky
Semester
Winter

Description
DATABASE MANAGEMENT SYSTEMS DATA AND INFORMATIONDataraw facts describing characteristics of an eventInformationdata converted into meaningful and useful contextDatabasemaintains information about various types of objects inventory events transactions people employees and places warehouses DATA VS INFORMATIONData shares in a stock marketInformation how did a certain stock perform in the past How does the performance compare to other stocksFirms need to make their data easily accessible by managers and employees TRANSACTIONAL DATA AND ANALYTICAL INFORMATIONTransactional Data packing slips sales receipts etc are put into a database which then provides Analytical information trends product stats sales projections etcAnalystsFine Transactional Data ExecutivesCoarse Analytical Data TRADITIONAL FILE ORGANIZATION FileGroup of records of File same type RecordRecordgroup of related fields FieldFieldgroup of words or a complete number ByteBytegroup of bits that represent a single character BitBitsmallest unit of data binary digit 01Databasegroup of related filesEntityperson place thing event about which information is maintainedAttributedescription of a particular entityKey fieldidentifier field used to retrieve update or sort a record
More Less

Related notes for ADM1370

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit