ISTM 210 EXAM 3 CURTSINGER QUESTIONS WITH GUARANTEED ACCURATE ANSWERS
10 views 0 purchase
Course
ISTM 210
Institution
ISTM 210
(ch.15-17, speaker 3, access)
what are alternate names for a table and its rows and columns in access? - ACCURATE ANSWERS - table= entity
- row= record
- column= field (titled with field names)
primary key field - ACCURATE ANSWERS uniquely identifies each record among all other records in a d...
ISTM 210 EXAM 3 CURTSINGER
ISTM 210 EXAM 3 CURTSINGER QUESTIONS WITH GUARANTEED ACCURATE
ANSWERS
(ch.15-17, speaker 3, access)
what are alternate names for a table and its rows and columns in access?
- ACCURATE ANSWERS✔✔ - table= entity
- row= record
- column= field (titled with field names)
primary key field - ACCURATE ANSWERS✔✔ uniquely identifies
each record among all other records in a database
like a UIN to a student
foreign key - ACCURATE ANSWERS✔✔ a field that is a primary key
in another table
,field names and attributes - ACCURATE ANSWERS✔✔ same thing
two kinds of attributes (field names) - ACCURATE ANSWERS✔✔
simple: can't be broken down any smaller; EX. first name
composites: field name can be broken down into something smaller; EX.
address can be broken into city
single v. multi value - ACCURATE ANSWERS✔✔ single: can only
have one; EX. age, SSN, UIN
multiple: can have more than one; EX. pets
null - ACCURATE ANSWERS✔✔ does not apply, it can be left blank
EX. asking for a home phone number, not everyones has one
Stored & Derived - ACCURATE ANSWERS✔✔ stored: attribute that
you wanted to know exactly and you ask. EX. you just ask for someone's
age
derived: you ask for something else and derive the data from other data.
EX. find out someone's age based off formula using todays date and
their birthday instead of asking for age
short text - ACCURATE ANSWERS✔✔ - data type used to store up to
255 characters of data in a field
- good data type for a field that stores small amounts of text, such as
names, cities, and states.
, description - ACCURATE ANSWERS✔✔ used to describe something
like how they always explain where to find the security number on the
back of a credit card
input mask - ACCURATE ANSWERS✔✔ A set of placeholder
characters that forces users to enter data in a specific format.
EX: SSN must have proper amount of digits and proper format
DBMS - ACCURATE ANSWERS✔✔ Database management system, a
software suite designed to organize and search data.
- first DBMS was filing cabinets
- lets you add/delete records
- query data
- answer questions immediately about data
- create reports
database - ACCURATE ANSWERS✔✔ Well thought-out collection of
computer files.
what are advantages of using databases? - ACCURATE ANSWERS✔✔
collection of data used to create records/forms
- can encrypt with password(bad if person leaves)
- easy to install & cheap
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller GRADEUNITS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.