Discuss entity sets, their attributes, and primary keys

Assignment Help Computer Engineering
Reference no: EM131724489

Draw an ERD diagram based on the Crow's Foot model for a database to support the basic operations of "Milky Way Jewelry".Specify:

• Entity sets, their attributes, and primary keys;

• Relationship sets and their descriptive attributes (if such exist);

• Connectivities and cardinalities;

• Decompose all M-M relationships, if any;

• If found, replace any multivalued attributes and composite attributes

• appropriately.Each piece of jewelry for sale is assigned a unique number, and is described by the name,sale price and a style.Each piece of jewelry can be made from one or more material, e.g. white gold anddiamond. The same material can be used to make many pieces of jewelry.

The materialsused and their amount for each piece must be recorded in the database. Materials aredescribed by material code, title and feature. A material can be a mixture of othermaterials. Then it is necessary to record the composition of the material including thepercentage of each mixed material. The same material can be used to make many kinds ofmixtures.For each piece of jewelry it is necessary to record the artist who created the piece of art.Information about artists is to be recorded in the database. It includes artist ID, name,address and phone number. One artist can create many pieces of jewelry. Each piece of jewelry can be only made by one artist.

Reference no: EM131724489

Questions Cloud

Mole of gas in cubic meters at standard pressure : Which is the volume of a one mole of a gas in cubic meters at standard pressure (1,013 hPa) and standard temperature (273 K)?
Describe the definition of a simple random sample : In a class of 20 students (John, Maria, Inez, Bill, etc.), a simple random sample of two people will be selected from the class. Use the definition of a simple.
Compute the per-unit cost for each product : Gerald Boards produces two kinds of skateboards. Gerald allocates production overhead using activity-based costing. Compute the per-unit cost for each product
Analyze the primary accounting issues : Analyze the primary accounting issues which form the crux of the litigation or fine for the firm, and indicate the impact to the firm as a result of litigation.
Discuss entity sets, their attributes, and primary keys : Draw an ERD diagram based on the Crow's Foot model for a database to support the basic operations of Milky Way Jewelry.Specify
What draws men to women together : What can transform the ecstasy of love into a cocaine-like addiction?What draws men to women together?
Explain how you could select the songs : A friend has recommended the work of a musician who has recorded five CDs, each containing ten selections. You decide to visit a music store and listen.
Determine the total amount of heat required : Use the following information on Na to determine the total amount of heat required to convert 150.0 g of solid Na at 48.0°C into gaseous Na at 883°C.
Explain importance of quality in a firms financial statement : Explain the importance of quality in a firm's financial statements and how you would go about evaluating the quality of a firm's financial statement.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

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