Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Construct an ERD for the following company 3.Replica Toys designs, develops, manufactures and markets sophisticated automated toys for children. Each toy is a complex replica

Construct an ERD for the following companyimage text in transcribedimage text in transcribed

3.Replica Toys designs, develops, manufactures and markets sophisticated automated toys for children. Each toy is a complex replica of an adult vehicle. Their ride-able toys include all-terrain vehicles, trucks, sports cars and vintage automobiles. Replica Toys sells directly to the public, but most of their toy sales are made through distributors such as FAO Schwarz (a fancy toy store). The company's toys are expensive so the company sells relatively few toys to those people looking for sophisticated, very high quality children's vehicles The purpose of the database is to keep track of toy registrations, A toy registration is the transaction for this particular system. In order to keep track of customers and their purchase of a given toy vehicle, Replica Toys asks all customers to fill out the online registration form shown on the next page. Customer information is used for future marketing. Because of the incentives offered by Replica Toys and the expense of the products, the people who buy toys from Replica Toys are willing to register the toy. Here is some information about the company nd the form: Each individual toy registration includes a toy's serial number. the form is the specific toy's serial number that is being registered. That toy is one representative of the model description "Jaguar XKE E Type" replica which fits within the #VBJAG model. For each model, the company keeps track of the description of the model (like "Jaguar XKE E Type) and the model number For example, serial #234-8009 on . There is only one "age" and "gender" per registration form. The age and gender of the user of the toy should be stored with the registration, since the user is most likely a minor and will not be identified personally in the database. We will not store the name of the toy's user . Each individual registration is related to only one customer, but a customer may register more than one toy. A customer is uniquely identified by a customer ID, and the customer data stored is shown on the registration form. The customer data sho registration data because a customer may register more than one toy . uld be stored separately from the In addition to the name of the toy's distributor, the company stores an email and phone number for each distributor. There is one distributor for each registration, but a distributor may be related to more than one registration. A distributor has at least one registration form associated with that distributor . This is a toy registration system. It is not a purchasing, inventory, sales, or ordering system. You do not have to keep track of sales data related to a purchase, except the data that is provided on the form. All data provided on the form must be maintained in the database. You are supposed to keep track of registrations made by customers for toys. However, it could be helpful to also keep track of toys that are not registered. . It is possible that a toy (uniquely identified by a serial number) may be registered more than once. We want to keep track of the history of which customer registered a toy on what registration date. . 3.Replica Toys designs, develops, manufactures and markets sophisticated automated toys for children. Each toy is a complex replica of an adult vehicle. Their ride-able toys include all-terrain vehicles, trucks, sports cars and vintage automobiles. Replica Toys sells directly to the public, but most of their toy sales are made through distributors such as FAO Schwarz (a fancy toy store). The company's toys are expensive so the company sells relatively few toys to those people looking for sophisticated, very high quality children's vehicles The purpose of the database is to keep track of toy registrations, A toy registration is the transaction for this particular system. In order to keep track of customers and their purchase of a given toy vehicle, Replica Toys asks all customers to fill out the online registration form shown on the next page. Customer information is used for future marketing. Because of the incentives offered by Replica Toys and the expense of the products, the people who buy toys from Replica Toys are willing to register the toy. Here is some information about the company nd the form: Each individual toy registration includes a toy's serial number. the form is the specific toy's serial number that is being registered. That toy is one representative of the model description "Jaguar XKE E Type" replica which fits within the #VBJAG model. For each model, the company keeps track of the description of the model (like "Jaguar XKE E Type) and the model number For example, serial #234-8009 on . There is only one "age" and "gender" per registration form. The age and gender of the user of the toy should be stored with the registration, since the user is most likely a minor and will not be identified personally in the database. We will not store the name of the toy's user . Each individual registration is related to only one customer, but a customer may register more than one toy. A customer is uniquely identified by a customer ID, and the customer data stored is shown on the registration form. The customer data sho registration data because a customer may register more than one toy . uld be stored separately from the In addition to the name of the toy's distributor, the company stores an email and phone number for each distributor. There is one distributor for each registration, but a distributor may be related to more than one registration. A distributor has at least one registration form associated with that distributor . This is a toy registration system. It is not a purchasing, inventory, sales, or ordering system. You do not have to keep track of sales data related to a purchase, except the data that is provided on the form. All data provided on the form must be maintained in the database. You are supposed to keep track of registrations made by customers for toys. However, it could be helpful to also keep track of toys that are not registered. . It is possible that a toy (uniquely identified by a serial number) may be registered more than once. We want to keep track of the history of which customer registered a toy on what registration date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Databases Technologies And Applications

Authors: Zongmin Ma

1st Edition

1599041219, 978-1599041216

More Books

Students also viewed these Databases questions