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
what is it when you want to populate usable data?
data validation rules which used to ensure using usable data
which object is used for presenting and decision making
reports
which is used to input data to where it automatically goes into the table
forms
which extracts data from the tables
queries
when you create a table and form which record is displayed first?
the first record from that table
when information is entered into a form
it goes into a record as the last latest record
which will allow you to input zip code, phone numbers, etc.
input mask
when trying to login into a tamu computer what does it make you do first
authenticate yourself
way to start applications
GUI
what is the standard called when its converting energy to 80%
80+ standard
what consists of an external hard drive
USB drives, flash drives, anything thats external and you plug into a computer to access data
pros and cons of backing up to an external hard drive
pros: another place to store data
cons easier to lose a hard drive than to lose a whole computer
is the cloud a better way to back up your data?
pros:
-its on demand and you can access it from anywhere
- you can determine what you want to see back up,
-easy to adapt and change scale up or down,
- you pay for what you use
cons:
- if you upload a corrupt file it could potentially corrupt the rest of your files
- security you’re not 100% sure where your information goes
what do you need to know before using the cloud in your business
- know the advantages and disadvantages
- only save things you need to be saved
- make sure everything is saved properly
- make sure you have access to it 24/7
- know when you need to scale up or down
what type of cloud would a drug company use
community
what do relational databases create
decrease redundancy, helps with mistakes, and scalable and flexible helps increase performance by keeping the data updated
what is it called when you’re trying to create a schema that creates visual representation
ERM, Enterprise Risk Management
what is it called when you’re trying to create a drawing that relates the attributes
ERD,Entity Relationship Diagram
business usually place databases for multiple access?
network
SQL is used to?
query data to extract data
CSP stands for
cloud service provider
what is the most common computer programming language called
SQL
what kind of relationship is it if a student is taking many classes
1:M
who created the internet
Tim berners Lee, his biggest regret lack of privacy and fake news
which type of malware is used to steal personal data and information
spyware
do IT professionals have an easier or harder time finding new jobs
easier
which dept. takes a systematic approach when developing new products?
research and development dept.
what are goods and services that are being sold called
products
what are something that can go wrong when backing up from an external hard drive?
corrupt files, if you lose it you dont know who could find it and get access to it
instead of saving everything to internal hard drive whats the best way to save data?
always make sure data is secured and backed up better to back up off site
what is called that godaddy tried to offer?
IDrive
what was the open source business software mentioned?
apache open office
what is it called when a business wants to rent software to try it out
SaaS
why did IDrive not make it
internet was too slow at that time
who is the person that created policies and procedures for networks
network admins
most common type of cable when creating a topology
twisted pair cable