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 2 relevant concepts that are specific business and industry needs.