computer essentials unit 7 short answer questions

User Generated

wqho94

Computer Science

Description

Answer the following questions thoroughly, and submit in a document. Each answer must be at least 150 words in length.

Cite your sources.

1. Describe seven database models, and give examples of each type.

2. Provide five examples of data you would store in a real, integer, text, logical, date, memo, and BLOB data field.

3. Using a real-world entity like a recipe file or collection of some sort that can be stored in a database, divide this

information into fields and record types. Explain the steps you need to take to normalize the data.

4. Explain in your own words the differences between sorting and indexing.

5. Imagine that you must access a library card catalog using SQL. Write an SQL query that you would use to search for

any books by J. J. Parsons in a table called Books, where author’s names are stored in a field called Title.

6. Explain the extent to which encryption, user privileges, and audits can secure a database.

All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying

citations.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: COMPUTER ESSENTIALS

1

Computer Essentials
Institution Affiliation
Date

COMPUTER ESSENTIALS

2

1. Describe seven database models, and give examples of each type.
A database model is used to describe the logical structure of a database and also
determines the way data can be stored in the database. There are several database models that
are available (Hernandez, 2013). The relational model is the most common model and it
sorts data in relations that are known as tables that have columns and rows e.g. student
registration database. A hierarchical model has its data organized in a tree-like structure
where each record has a single parent or root e.g. University database. A network model
allows many-to-many relationships to be formed between records that are linked e.g.
suppliers database. Object-oriented model sees a database as a collection of related objects
e.g. telecommunications database. Entity-relationship model will try to capture relationships
between entities in the real world e.g. business processes database.
2. Provide five examples of data you would store in a real, integer, text, logical, date,
memo, and BLOB data field.
In a database, a field refers to a single piece of information derived from a record. A
record is made up of a group of fields. Different types of data can be stored in the different
fields within the table. Examples of real data fields are per...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags