When trying to design a database, how would you identify the functional dependencies associated with a relational database?

/in /by

Due 11/23/16 @8:00 100% original work 400-600 words with at least 2 references APA format

 

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are better to house data for an entire organization. Discuss the following:

 

  • Explain why SQL or Access is better suited for an entire organization.
  • When trying to design a database, how would you identify the functional dependencies associated with a relational database?
  • Identify at least 5 relevant concepts that are specific business and industry needs.

 

Dimensional modeling is related to normalization of data. Discuss the following:

 

  • List 8 factors that would be important to customer identification using the dimensional model.
  • Explain why data should be consistent among customers.