Question: 1. The following E-R model describes data about customers. Common data for all customers are ID, Name, Address, and Contact including Phone and Emai. Special

1. The following E-R model describes data about customers. Common data

1. The following E-R model describes data about customers. Common data for all customers are ID, Name, Address, and Contact including Phone and Emai. Special data for online customers are LoginName and Password. (a) Perform specialization to the E-R model to produce an E-R model with the superclass entity, Customer, and a subclass entity, OnlineCustomer. (b) Give at least one instance of the superclass and the subclass entity in part (a). Phone Email C D Name Name ( Address Address Contact Contact ( LoginName) LoginName ( Password Password Customer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

On June 4, Marie Company had cash sales rung up by cashiers totaling $120,500. Cash in the drawer was counted and found to be $126,000. The journal entry to record the sales for June 4, would include...

IEE 305, Exercise 1.5 1. The following E-R model describes data about customers. Common data for all customers are ID, Name, Address, and Contact including Phone and Emai. Special data for online...

7.0: Organizational Strategy Overview (one paragraph describing the following charts) 7.1:CurrentOrganizationalStructure(chart)...

Database Systems Project BEST CAKES : BEST cakes is a shop that makes and sells cake . Summary: BEST CAKES shop buys raw ingredients from several suppliers. Employee prepares cakes. Employee sells...

ABC Pharmacy (ABC) is a large, online retail pharmacy chain based in Ypsilanti, Michigan. With over 50 stores across the state, the company provides customers with prescription filling services. ABC...

Scenario: A manufacturing company, Teleworks, has been a leader in the cellphone market for the last 10 years. Other firms have imitated its product with some degree of success but Teleworks is...

A list of database application projects is available at http://www.dssbooks.com/web/ProjectsManual.html Project 48 describes a database application for a movie theater. The movie theater database...

Background: Baer Belly Bikinis Inc. (BBB) is a small business located in Santa Monica, California. It sells swimwear and related products to specialty stores throughout the United States. It also...

Here is the script given: Looking for the answer to the Advanced Challenge Quetion. CREATE TABLE warehouses (wh_id NUMBER(2), location VARCHAR(12) ); INSERT INTO warehouses VALUES (10, 'Boston');...

List and briefly describe the most common social network types.

Cathy, the manager of Cathy's Catering, Inc., uses activity-based costing to compute the costs of her catered parties. Each party is limited to 20 guests and requires four people to serve and clean...

Chapter 4 Problem 2: A pet owner has a mixed breed beagle jack-Russell terrier mix rescue dog. She estimates the cost of pet ownership for 13 years: Initial cost to rescue: $100 Vet fees $250 per...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Assume that you are preparing a visual aid that will not fit on the page with the text that relates to it. Where would you place this visual aid in the report? (Objective 2)

Construct a graph for the following data. Include appropriate content, placement, and format for the number of the visual (assume it is the first visual in a report), title, and source note. Assume...

You have several items to compare differences in quantities. What type of graph would you prepare? Why? (Objective 4)