ISYS104 Study Guide - Quiz Guide: Process Modeling, Business Process Model And Notation, Object Management Group
31 May 2018
School
Department
Course
Professor
ISYS CHAPTERS 5-7 REVISION
Chapter 5
Q1: What is the purpose of data base? The purpose of a database is to keep track of things and
organise that involve more than one theme e.g excel
Q2: What is Database?
- A self-describing collection of integrated records
- Collection of tables plus relationships among rows
- Also, iludes etadata
- Describes the structure of the database
Metadata
- Database is self-describing
- Data that describe data
- Make databases more useful/easier to use
- Examples: Field name, Data type, Field properties, Description
Q3: What are the Components of a Database Application System?
- A database application system makes the data from a database more accessible and useful.
Comprises:
- A user who uses the database application
- Forms, reports, queries and other application programs
- A database management system to process the database
- A database containing tables, relationships and metadata
User → Data base apps → DBMS → Database
- Forms - Database - Tables
- Reports management - Relationships
- Queries systems - Metadata
- Apps
- Programs
Database Management Systems (DBMS)
- A program used to create, process and administer a database
- Usually licensed from vendors
- DBMS products include Microsoft Access, Oracle, MySQL, DB2
- A DBMS and a database are different
- A DBMS is a software program
- A database is a collection of tables, relationships and metadata
Processing the Database
- A major function of a DBMS is to process the data in a database
find more resources at oneclass.com
find more resources at oneclass.com
- Four processing operations of a DBMS are Read, Insert, Modify, Delete
- Structured Query Language (SQL)
Administering the database
- DBMS provides tools to administer a database
- Administrative functions
▪ Security
- Used to set up user accounts, passwords, permissions, processing limits
- Permissions are data access rights for specific users or groups of users
▪ Backing up data
▪ Structures to improve performance
▪ Removing data that is not required
Q4: How Do Database Apps Make Databases More Useful?
- Collection of forms, reports, queries and application programs that process a database
- Databases can have multiple apps
- Apps can have multiple users
Forms, reports and queries
- Forms: Used to read, insert, modify and delete data
- Reports: Show data in structured context
- Queries: Are a means of getting answers from database data
Enterprise DBMS and a Personal DBMS?
▪ Enterprise DBMS
- Processes large organisational and workgroup databases
- Supports many users (thousands)
- Examples: DB2, SQL Server, Oracle, DB2
▪ Personal DBMS
- Designed for smaller, simpler database apps
- Supports fewer than 100 users
- Examples: Access, dBase, FoxPro, Paradox, R:base
What are the Components of the Entity–Relationship Data Model?
- Data Model: Logical representation of the data to be stored in the database
- Entities: Something users want to track, e.g. order, customer, salesperson, item, volunteer,
donation
- Attributes: Describe characteristics of an entity, e.g. OrderNumber, CustomerNumber,
VolunteerName, PhoneNumber
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
The purpose of a database is to keep track of things and organise that involve more than one theme e. g excel. Collection of tables plus relationships among rows. Examples: field name, data type, field properties, description. A database application system makes the data from a database more accessible and useful. A user who uses the database application. A database management system to process the database. A database containing tables, relationships and metadata. User data base apps dbms database. A program used to create, process and administer a database. Dbms products include microsoft access, oracle, mysql, db2. A dbms and a database are different. A database is a collection of tables, relationships and metadata. A major function of a dbms is to process the data in a database. Four processing operations of a dbms are read, insert, modify, delete. Dbms provides tools to administer a database. Used to set up user accounts, passwords, permissions, processing limits.
