Question

Find entities, attributes, and relationships for a simple address database. Develop the corresponding layout of relations. Which attributes can be used as keys? Provide for the entry of optional information, such as phone and fax number(s), occupation, and so on. Test your design by solving the following problems with it: 1. Print a list of all persons having the same address. 2. Make entries for father and son having the same first and last names and living at the same address. 3. Change of name at marriage. 4. Addresses in various countries, for example: MathConsult Dr. R. Mäder Samstagernstraße 58a 8832 Wollerau Switzerland Tel: +4116874051, Fax: +4116874054

   Find entities, attributes, and relationships for a simple address database. Develop the corresponding layout of relations. Which attributes can be used as keys? Provide for the entry of optional information, such as phone and fax number(s), occupation, and so on. Test your design by solving the following problems with it:
1. Print a list of all persons having the same address.
2. Make entries for father and son having the same first and last names and living at the same address.
3. Change of name at marriage.
4. Addresses in various countries, for example:
MathConsult Dr. R. Mäder
Samstagernstraße 58a
8832 Wollerau
Switzerland
Tel: +4116874051, Fax: +4116874054

Computer science with Mathematica: theory and practice for science, mathematics, and engineering

Roman Maeder 1st Edition

Chapter 13, Problem 2

Instant Answer

Step 1

For an address database, the primary entities could be: - Person - Address - Country Step 2: Define Attributes for Each Entity Each entity will have various attributes associated with it: - Person: person_id, first_name, last_name, phone_number, fax_number, Show more…

Show all steps

Thanks for your feedback!

Find entities, attributes, and relationships for a simple address database. Develop the corresponding layout of relations. Which attributes can be used as keys? Provide for the entry of optional information, such as phone and fax number(s), occupation, and so on. Test your design by solving the following problems with it: 1. Print a list of all persons having the same address. 2. Make entries for father and son having the same first and last names and living at the same address. 3. Change of name at marriage. 4. Addresses in various countries, for example: MathConsult Dr. R. Mäder Samstagernstraße 58a 8832 Wollerau Switzerland Tel: +4116874051, Fax: +4116874054

Play audio

Feedback

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later

Please give Ace some feedback