Appropriate cardinalities and all the applicable constraints

Assignment Help Basic Computer Science
Reference no: EM132336903

Question

Draw an E-R diagram for the given description. Show appropriate cardinalities and all the applicable constraints. Clearly state any assumptions that you may have made. Your assumptions cannot contradict the given description.

A fiberglass manufacturer, Floating Fiber Inc. (FFI), specializes in manufacturing boats. The company has only two types of customers, retail and wholesale. For retail customers, FFI wants to store name (identifier), address and cost of the previous boat(s) owned. For wholesale customers, FFI wants to store name (identifier), address and Tax ID Number. There are three kinds of boats that the company makes: sailboats, rowboats and fishing boats. For all different types of boats that FFI manufactures, it wants to store ID (identifier) and the size of the boat (which is composed of the length and the maximum capacity). Customers can place orders for boats. A customer can purchase one or many boats and each boat is purchased by exactly one customer

Reference no: EM132336903

Questions Cloud

Whitespace and newline characters : If possible I'd also like to reprint all the digits the user inputted after it was determined whether or not the sum is odd or even.
Business applies corporate social responsibility : Evaluate how the business applies corporate social responsibility within its decision-making processes. Select major business decision recently made by business
Explain the nature of groups and group behaviour : Human Resource Management Institute-Edexcel BTEC HND in Business – HRM -Organizations and Behaviors-how organisational theory underpin practice of management.
Business applies corporate social responsibility : Evaluate how the business applies corporate social responsibility (CSR) within its decision-making processes.
Appropriate cardinalities and all the applicable constraints : Draw an E-R diagram for the given description. Show appropriate cardinalities and all the applicable constraints. Clearly state any assumptions that you may
Mate selection individuals have ideal mate : Everyone has preferences when it comes to mate selection! Individuals have an "ideal mate" and sometimes make extensive lists to find that person.
Information security management frameworks : Evaluate and compare information security management frameworks ISO 27000 Series and CMMI.
Primarily on the surface of your external barriers : Gram positive organisms live primarily on the surface of your external barriers. What if these bacteria were to get inside your body? Would they cause disease?
What characteristics of the male reproductive system : What characteristics of the male reproductive system are different from a woman's? What characteristics are the same?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Wi-fi upstream vs downstream

On wireless WANs, downstream data transmission is typically faster than upstream transmission. What types of limitations does this bring to an office environment? Why do you think this should be a consideration in WAN configuration?

  Create a drill routine of your own for the toy soldiers

Create a drill routine of your own for the toy soldiers world from Tutorial 8B that demonstrates the use of the For all in order and For all together instructions, along with good modular programming techniques.

  What is the herfindahl index for the industry

A market is composed of five firms, and their market shares are 30 percent, 25 percent, 20 percent, 15 percent, and 10 percent.

  Competitive advantage in a business

Provide an example of how Information Technology has created a competitive advantage in a business.

  What is the difference between cdma and lte

What is the difference between CDMA and LTE? Is one technology better than the other?

  Choose to do four questions out of five on a test

In how many ways can a student choose to do four questions out of five on a test?

  What are the configuration entries used

What are the configuration entries used in the /etc/dhcp/dhcpd.conf file to specify the TCP/IP parameters for IP address range

  Discuss the key components of leadership

Discuss the key components of leadership and how they align with the 5 practices of exemplary leadership.

  Formulate the problem as a max-flow problem

Solve the problem of part (a) using the max-flow algorithm of Section 3.3.2 for the case where n = 8, and the squares A and B are two opposite corners of the board.

  What is the value of the friction factor for this duct

What is the value of the friction factor for this duct and the approximate size of the equivalent roughness of the surface of the duct?

  Instantaneous rate of change

Given that the line y = 2/3x - 8 is tangent to the graph of y = f(x) at x = 6, find

  Od action research model

Describe the set of steps in the OD Action Research Model, Appreciative Inquiry, and Kotter's Eight Step Model.

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