- Define the term, database, and explain how a database interacts with data and information
- Define the term, data integrity, and describe the qualities of valuable information
- Discuss the terms character, field, record, and file
- Describe file maintenance techniques and validation techniques
- Differentiate between a file processing approach and the database approach
- Discuss the functions common to most database management systems
- Explain how to access Web databases
- Describe characteristics of relational, object-oriented, and multidimensional databases
- Identify database design guidelines and discuss the responsibilities of database analysts and administrators
Step of How a School's Admissions Department Might Process New Student Data into Information
- Admin take student picture
- Student data stored into database
- computer extract data-advisor name, schedule appointment, course taken
- comfirmation of advisiry appointment
- Admin give student ID with expired date
The Hierarchy of Data
- Character
- field
- records
- files
Common Data Type Include
- Text
- Numeric
- AutoNumber
- Currency
- Date
- Memo
File maintenance refers to the procedures that keep data currnt
- Adding records
- Modifying records
- Deleting records
Validation compares data with a set of riles or values to find out of the data is correct
- Alphabetic / Numeric Check
- Range check
- Consistency Check
- Completeness Check
- Check Digit
- Other Check
No comments:
Post a Comment