Music Performers MS Access Database
Not what you're looking for?
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.
Purchase this Solution
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.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Javscript Basics
Quiz on basics of javascript programming language.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.