Explore BrainMass

Music Performers MS Access Database

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Design a relational database containing information about music performers, their recordings, and the composers of the music they recorded.

The following elements must be included:
- Database file contains at least three tables.
- Relationships between the tables are shown.
- Each table contains three or more attributes.
- Each table contains at least three records.

In addition:
Write a brief essay (at least four paragraphs) explaining why a relational database was the best choice for this project as well as explaining the reasoning behind the relationships within the database. Essay must be logical and free of grammar and spelling errors.

© BrainMass Inc. brainmass.com October 25, 2018, 5:37 am ad1c9bdddf

Solution Preview

A relational database is designed to relate groups of information using key data values. For example, a person has a set of attributes that only he or she possesses and are single-instance in nature, such as age, height, weight, gender, etc. But a person can have multiple addresses or phone numbers. If all of a person's multiple address and phone number information were stored in the same file as the other data, the per-person data (singletons) would be need to be replicated for each new address row or phone number row in order for the system to know which address or ...

Solution Summary

The solution provides an MS Access 2010 database file attachment with three tables, each containing three records. A screen print is attached showing how the table relationships are defined. The solution also provides four paragraphs of explanation on the principles of relational database design and data normalization.

See Also This Related BrainMass Solution

Database Back up

Please discuss what you believe to be a good backup and crisis management strategy considering the following scenario. Provide a detailed explanation of your choices. Be sure to cite your sources.

You work for a small consulting firm with a sterling reputation for high-quality work and outstanding technical aptitude. You've been assigned as the SQL Server 2000 DBA for an e-commerce project based in coastal Florida. Your client is a well-financed, Internet startup firm focusing on creating an online billing system for large hospitals. As a startup firm, they have limited financial resources and must stringently manage their budget.

There are three database environments for your project: development, staging, and production. The development environment is for the web development to create and test their modules and code. The staging environment is where the various components are assembled and tested as a whole. The production environment is the environment that will eventually be your deliverable to the client and will migrate to become the live web presence for the start up.

The client has approached you in the database server room. She's heard there is severe weather coming to the area that may escalate to hurricane status. She would like you to describe in the detail the backup strategies you've developed for each database environment. She'd really like to know how you can save the company money by applying differing backup and crisis management systems to the varying database environments.

View Full Posting Details