Number of sources: 5
Primary Task Response: Within the Discussion Board area, write 600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
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.