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.
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...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Catching Fire
by Suzanne Collins
Nervous Conditions
by Tsitsi Dangarembga
Broke Millennial: Stop Scraping by and Get Your Financial Life Together
by Erin Lowry
Daisy Miller
by Henry James
Into the Wild
by Jon Krakauer
Death on the Nile
by Agatha Christie
Narrative of the Life of Frederick Douglass
by Frederick Douglass
And Then There Were None
by Agatha Christie
The Curious Case of the Dog in the Night Time
by Mark Haddon