Unit VII Scholarly Activity

 

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

SophiaPretty

(5)

Status NEW Posted 30 Nov 2017 06:11 AM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer