LECTURE 3. Data
- Data is raw facts or basic descriptions of things, events, activities, and transactions
- A database is an organized collection of related data 1-4 Database DBMS
- Nowadays, most databases are made and used with a Database Management System (DBMS)
- A DBMS makes it easier to work with a database by providing a user interface and other tools. DBMS (cont.) - Some common DBMS are - MySQL - Microsoft Access - Microsoft SQL Server - Oracle - Sybase - Informix Quick Review
- A Primary Key is a field (or column) in a table which identifies each row in a table uniquely
- Relationships between tables are created by taking the Primary Key from
one table and putting a copy of it in another table
- The copy of the Primary Key in the other table is called a Foreign Key. Definitions
- Database: Tables, forms, queries, reports in one file.
- Record: A set of Data about a person or thing.
- Field: A category of information that pertains to all records (in a column format).
- Value: A single piece of data. Definitions
- Table: A group of records and fields stored as rows and columns.
- Query: A question the searches a database for information.
- Form: A document used to input table data, arranged in an order specified by the user.
- Report: Graphic interface used to display the output of a table or query.
- Primary Key: The Primary Key is a combination of fields that contain
values that uniquely define records.