Answered step by step
Verified Expert Solution
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 company
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 dateStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started