can contain one or many tables
used to determine how data is organized or sequenced in a table
Most business managers will link to tables contained in external database systems known as _______ __________ or ________ ________.
the tool used to extract, manipulate, and calculate data from a table is called a ______.
fields created in a query but are not included in a table
you can create formulas by using this tool
a feature that creates the join line automatically
sometimes referred to as a Simple Join of an Equal Join
How will we use Abstract Reasoning?
Number of transistors per square inch on an integrated chip roughly doubles every 18-25 months
characteristics and things that describe the entity.
Attributes of Students would be class ranking, address, grades, academic standing (Freshman, Junior, etc..)
something that needs to be tracked.
key to be the main key for the relation.
If you know the value of the primary key, you will be able to uniquely identify a single row.
A request for info from a database.
Ex: A way to find out how many customers live in Arkansas, etc..
set of rules that help control how data is entered into a field.
helps ensure accuracy by minimizing entry errors
development and use of information systems that help businesses achieve their goals and objectives
3 Key Elements:
- development and use
-business goals and objectives
who made what changes, when, and why;
Access permissions to create, edit, delete, and read only various content
1. shared knowledge management
2. repository of team knowledge
3. keeps track of: who created it, date of creation and modification
ex. Google Doc
each team member is given an account w/ a set of permissions which grant access to shared directories/libraries
---highest level of control
A form of hardware or software leasing in which organizations obtain server resources from vendors that specialize in server processing
Flat fee payment for right to install software product on all company computers or all computers at a specific site
create tables, add and delete fields, and modify field properties.
record source data not shown here
keep track of things with multiple themes (ex. student's grades, email, visits)
1. rows contain data about one entity
2. columns contain data about attributes of the entities
3. all entries in a column are of the same kind
4. each column has a unique name
5. cells of the table hold a single value
6. the order of the columns is unimportant
7. the order of the rows is unimportant
8. no two rows may be identical
o Relevant to context and subject
o Just sufficient enough
o Worth its cost
contents survive when power is off.
Ex: Magnetic tape and optical disks(Hard drive, CD, DVD)
Attributes that describe entities.
Smallest data element contained in a table.
Main components that are created to make the DB function.
MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)
Given the above functional dependency, which of the following statement is not known to be true?
A) MedicineCode is a determinant.
B) MedicineName is a determinant.
C) Manufacturer is functionally dependent on MedicineCode.
D) ShelfLife is functionally dependent on MedicineCode
CIS are used for _ Control – POSX systems
Examples of things made possible b/c of Moore’s law (Moore's law is the observation that, over the history of computing hardware, the number of transistors on integrated circuits doubles approximately every two years):
Any new system requires training tasks overcoming employees’ _ to change and managing employees as they utilize the new system
What is wrong with using adviser name as a primary and foreign key?
Data value may be shared among several rows.
Consequently, the key will identify a set of rows.
Data value is unique for each row.
Consequently, the key will uniquely identify a row.
(FamilyID, FirstName, Suffix).