100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
ISTM 210 EXAM 3 CURTSINGER QUESTIONS WITH GUARANTEED ACCURATE ANSWERS $14.99   Add to cart

Exam (elaborations)

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...

[Show more]

Preview 3 out of 19  pages

  • September 10, 2024
  • 19
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • ISTM 210
  • ISTM 210
avatar-seller
GRADEUNITS
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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

71947 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$14.99
  • (0)
  Add to cart