Database Systems

 

1. Why are I/O (input/output operations) important in database environment?

2. Give two examples of persistent media?

3. What is the importance of logically separating the definition of a database (or file),
the "schema", from the physical stored database (file)?

4. What does it mean to say that the conceptual schema is the "common denominator" of multiple
user views and internal stored representations?

5. Does an operating system (DOS, Unix, NT) have a "data dictionary"? If so, can a user access it?
How?

6. Why are the interfaces in the ANSI/SPARC model numbered 34 through 38 important?

7. Why is an enterprise statement important?

8. Why are metadata important?

9. How does the ANSI/SPARC model relate to data independence?

 

10. Fred owns and runs a specialty grocery store. Fred keeps a special information about his customers, For example, a profile of purchase (stored as a separate sequential list for each customer), credit card information ( number, expiration date, charge limit at this store). etc .. customers can submit lists of desired items over the internet and stop later to pick them up (or have them delivered). 

suppliers deliver goods to Fred's store. each supplier has some amount of shelf space upon which to display the products. current count (inventory level) are maintained on each product. suppliers may access the inventory level for their products.

contain business rules must be enforced, some are: 

- Order products id stock (inventory) is low

- Deny credit if customer's limit is exceeded 

- Notify customers if credit card is about to expire or changes are near credit card limit.

- Suggest items a customer may need based on past purchasing trends 

Also Fred wants to be able to see details about suppliers and customers.

Classify the items above as to whether they fit into the 3 layer architecture at the external, conceptual or internal levels.

 

External :

 

Conceptual:

 

 

Internal:

ComputerScienceExpert

(11)

Status NEW Posted 27 May 2017 05:05 AM My Price 9.00

-----------

Attachments

file 1495862423-Solutions file 2.docx preview (51 words )

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 -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer