Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Question 3: ERD design Although you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was born, a name (not unique), the type of dog (e.g., Brittany, German Shepard, Collie, etc.), color of the dog's hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each kennels keep information about customers. For each customer, kennels keep that person's last name (which is not unique), first name (which is not unique), address, age (a derived value), date of birth, monthly income (very important!), and the dog types (NOT GROUPS) of dogs that the customer tends to like. group is identified by a name (like those just given) that describes the group. Finally, 3.1) Draw the ER diagram for the database. 3.2) Identify the relational schema for the database. Make sure to clearly indicate primary keys and foreign keys. You can add an ID integer PK attribute to any entity, where it makes logical sense to do so.

Question 3: ERD design Although you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was born, a name (not unique), the type of dog (e.g., Brittany, German Shepard, Collie, etc.), color of the dog's hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each kennels keep information about customers. For each customer, kennels keep that person's last name (which is not unique), first name (which is not unique), address, age (a derived value), date of birth, monthly income (very important!), and the dog types (NOT GROUPS) of dogs that the customer tends to like. group is identified by a name (like those just given) that describes the group. Finally, 3.1) Draw the ER diagram for the database. 3.2) Identify the relational schema for the database. Make sure to clearly indicate primary keys and foreign keys. You can add an ID integer PK attribute to any entity, where it makes logical sense to do so.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
Question 3: ERD design Although you always wanted to be a dog trainer, you ended up being an expert on databases because love to work with data and logic. Your old love is still there, however, so you set up a database you company, Dog Training, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the infonmation that kennels need to maintain Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was bom, a name (not unique), the type of dog (e.g. Brittany, German Shepard, Collie, etc.), color of the dog's hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels keep information about customers. For each customer, kennels keep that person's last name (which is not unique), first name (which is not unique), address, age (a derived value), date of birth, monthly income (very important!), and the dog tvpes (NOT GROUPS) of dogs that the customer tends to like. 3.1) Draw the ER diagram for the database. 3.2) Identify the relational schema for the database. Make sure to clearly indicate primary keys and foreign kevs. You can add an ID integer PK attribute to any entity, where it makes logical sense to do so.
Transcribed Image Text:Question 3: ERD design Although you always wanted to be a dog trainer, you ended up being an expert on databases because love to work with data and logic. Your old love is still there, however, so you set up a database you company, Dog Training, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the infonmation that kennels need to maintain Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was bom, a name (not unique), the type of dog (e.g. Brittany, German Shepard, Collie, etc.), color of the dog's hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels keep information about customers. For each customer, kennels keep that person's last name (which is not unique), first name (which is not unique), address, age (a derived value), date of birth, monthly income (very important!), and the dog tvpes (NOT GROUPS) of dogs that the customer tends to like. 3.1) Draw the ER diagram for the database. 3.2) Identify the relational schema for the database. Make sure to clearly indicate primary keys and foreign kevs. You can add an ID integer PK attribute to any entity, where it makes logical sense to do so.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS