Exam (elaborations)
MISY 5335 QUESTIONS ANDANSWERS 2024
- Course
- Institution
Exam of 8 pages for the course MISY at MISY (MISY 5335)
[Show more]
Content preview
MISY 5335Why Use a Database? - answerA database is used to help people keep track of things,
and the most commonly used type of database is the relational database, although
nonrelational databases (which are used extensively in online applications such as
Facebook and Twitter) are now also widely used.
What are the Problems with Using Lists? - answermaking changes to this list
causes ...modification problems..
Modification problem - answerA situation that exists when the storing of one row in a
table records facts about two themes or the deletion of a row removes facts about two
themes, or when a data change must be made in multiple rows for consistency.
null values - answermeans a missing value. Are always problematic and that we want to
avoid them whenever possible.
relational model - answerA data model in which data are stored in relations and
relationships between rows are represented by data values.
relational database - answercontains a collection of separate tables
table - answerholds data about one and only one theme in most circumstances.
row - answerhas data about a particular occurrence or instance of the thing of
interest...A group of columns in a table. All the columns in a row pertain to the same
entity. Also known as tuple or record.
instance - answerA specific occurrence of an object of interest.
Record - answer(1) A group of fields pertaining to the same entity; used in file-
processing systems. (2) In the relational model, a synonym for row and tuple.
column - answerstores a characteristic common to all rows...A logical group of bytes in
a row of a relation or a table. The meaning of a column is the same for every row of the
relation, and represents an attribute of a relation.
Field - answerThe central table in a dimensional database. Its attributes are called
measures. See also measure.
...(1) A logical group of bytes in a record used with file processing. (2) In the context of
the relational model, a synonym for attribute.
, modification actions - answerinsert, update, and delete...An action that changes the
value of a data item.
Structured Query Language (SQL) - answerinternational standard, emerged as the
leading technique for data definition and manipulation.
Using SQL, you can? - answerreconstruct lists from their underlying tables; you can
query for specific data conditions; you can perform computations on data in tables; and
you can insert, update, and delete data.
What is a Database System? - answera database system has four components: users,
the database application, the database management system (DBMS), and the
database.
database - answeris a collection of related tables and other structures
- answer
database management system (DBMS) - answer.is a computer program used to create,
process, and administer the database
.receives requests encoded in SQL and translates those requests into actions on the
database
.a large, complicated program that is licensed from a software vendor; companies
almost never write their own DBMS programs.
database application - answer.a set of one or more computer programs that serves as
an intermediary between the user and the DBMS
.read or modify database data by sending SQL statements to the DBMS
.present data to users in the format of forms and reports
.acquired from software vendors, and they are also frequently written in-house
Users - answer.employ a database application to keep track of things.
.use forms to read, enter, and query data, and they produce reports.
database - answera self-describing collection of related records/related tables
self-describing - answera description of the structure of the database is contained within
the database itself.
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 julianah420. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now