Review Questions Flashcards
Which software is a set of programs that helps the user to complete tasks?
application software
Leading and following
are business strategies
Motherboard
is considered a primary circuit board
Entities
store information/data about a person, place, thing, transactions and events
where do businesses store their information before business databases? comes along?
filing cabinets
when creating queries where are they being stored at?
navigation pane
a row in a data table is called a what
a record
what is it called when trying to clarify purpose of information
field description
which views modify the structure of the table
design view and data sheet view
what is the difference between entity and attribute?
entity is a table and attribute is a field, difference is entity stores person, place, etc. and attribute represents the specific information that has been input in a table
database allows you to:
create, read it, update it, and delete
which attribute can be calculated by using another attribute
dependent attribute, derived
advantage and disadvantage of access
multiple users that is both an advantage and disadvantage
what to avoid when creating a well thought report..?
redundancy
what is considered a composite attribute?
things like an address which can be broken down into simple
what is considered to be a multivalued attribute?
things that you can get 2 more of like cars, degrees, books, groceries, etc.
single attribute
special unique only one of those like UIN, drivers license number, age
things to expect to find in the TAMU database?
UIN, address, name, birthdate
things you would NOT expect to find in TAMU database
weight, height
what are some comparison operators?
<,>,=,<=,>=
what are some of the files that can be inputed into access?
excel, text files, html, xml
2 kinds of views
design and layout view
whats one field that needs to be unique?
primary key