Types of Questions:
1)
Q1: Definition/Terms
2)
Q2: sum(2:3)
3)
Q3: Screenshot
1)
What is info system?
a)
4 components
2)
What is database?
a)
-What is the benefit and what does it minimize and maximize?
3)
Attribute(field) relationship, entity, record(instance), table
4)
Primary key, compositional primary key, foreign key
a)
Unique field
b)
Unique combination of fields
5)
What is form? (def, why we use form)
6)
What is query? (def, why we use it?)\
a)
4 types of queries:
i)
Update
ii)
Select
iii)
Total
iv)
Parameter
7)
Report
8)
Cardinality, Modality (def, ERD)
a)
ERD graph
b)
Know symbols and how to read the relationships
9)
SQL
a)
SELECT____FROM_____
WHERE
_____
10) Excel-Week 3
a)
Related with Decision support system
You've reached the end of your free preview.
Want to read the whole page?
- Spring '13
- Unknown
