Gap is developing its database using object-oriented methods

Assignment Help Database Management System
Reference no: EM13950178

Assume that GAP is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram on next page. Specifically, they want to make ProductItem an abstract parent class (entity) from which more specific product classes are specialized.

Three specialized classes will be added:

ClothingItem - ClothingItem will add the attribute Color and that same attribute will be removed from the InventoryItem class.

EquipmentItem - Equipment item will also add an attribute called Color but will not have an attribute called Gender.

OtherItem - OtherItem will have both the Color and Gender attributes.

Attachment:- GAP.doc

Reference no: EM13950178

Questions Cloud

Calculate the fair market price for the call option : Calculate the fair market price for the call option. Assume that you sell 1000 shares of the option for the fair market price + $0.12. How many shares of stock should you buy to hedge the sale? What is your profit, independent of the outcome of stock..
Variation of the traders profit with the asset price : A trader sells a call option with a strike price of $45 and a put option with a strike price of $40. Both options have the same maturity. The call costs $3 and the put costs $4. Draw a diagram showing the variation of the trader’s profit with the ass..
Collaborative learning community health promotion present : In this group assignment, you will be developing a presentation on childhood diseases that exist in adults. To complete this assignment, access the "Collaborative Learning Community: Health Promotion Presentation" resource.
Transactions expenses by netting intra company debt : Trident Europe, the German subsidiary of a U.S. company, has €15,000,000 in accounts receivable for sales billed to customers on terms of 2/30 n/60. Customers usually pay in 30 days. Trident Europe also has €9,000,000 of accounts payable billed to it..
Gap is developing its database using object-oriented methods : Assume that GAP is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram on next page. Specifically, they want to make ProductItem an abstract parent clas..
What is the cost of the ending inventory of calendar on hand : How many calendars did agents take to give to clients during January? What is the cost of the calendars given out? What is the cost of the ending inventory of calendars on hand?
Comparing two different capital structures-equity under plan : OOke Co. is comparing two different capital structures. Plan I would result in 8,500 shares of stock and $402,500 in debt. Plan II would result in 12,000 shares of stock and $280,000 in debt. The interest rate on the debt is 11 percent. The all-equit..
Individual health history and examination assignment : Perform a health history on an older adult. Students who do not work in an acute setting may "practice" these skills with a patient, community member, neighbor, friend, colleague, or loved one. (If an older individual is not available, you may cho..
Prepare statement of cost of goods manufactured for february : Prepare a statement of cost of goods manufactured for February. Prepare a statement of cost of goods sold for February.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Query evaluation and query optimization

Explain what you understand by the terms Query Evaluation and Query optimization - Discuss the ways or strategies you can apply to improve the query performance

  Discuss landmark contributions made in development of ehr

Discuss the landmark contributions made in the development of the EHR. Include pioneers and describe their efforts.

  What classes are necessary to obtain a specific degree

What degree is the student working towards. A student can only work on one degree at a time. What classes are necessary to obtain a specific degree

  Identify five different it systems that have affected

identify five different it systems that have affected business in the past few years i.e. business software

  Systems analysis and database designyou should back up your

systems analysis and database designyou should back up your answers with theoryreferences from reliable sources - more

  Define the digital divide and the impact of the olpc

The Digital Divide and the impact of the OLPC initiative. Write a 1 page summary for each article and include the proper citations.

  Create a tables student that print names of students

Create the following tables: student (sid, sname, sex, age, year, gpa) that Print the names of the students with the lowest GPA.

  Write table in dbdl notation after applying methodology

Proceed with all steps in information-level design to add this user view to existing cumulative design. Is this table in1st NF?___No____ . If Yes skip. If not, write Table in DBDL notation after applying the methodology we use for converting into 1NF..

  Planning & implementing a data warehouse project

ABC Industries is a diversified global organization that provides a variety of services, including financial and technical, and manufactures its own numerous products. Its manufacturing base is spread across the globe. ABC's production facilities ..

  Convert the erd

Using the descriptions of the attributes given in the, convert the ERD shown in Figure P6.2 into a dependency diagram that is in 3NF.

  Database with data about a university

This assignment uses a database with data about a university; the database resides in our Oracle servers. The schema of the database is provided below. Keys are in bold face and underlined, field types are omitted; assume that appropriate foreign ..

  Explain class diagram

Explain Class diagram. Outline the main steps in developing a class diagram for a Use Case(UC).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd