Draw an orm diagram for lineiteminvoice

Assignment Help Database Management System

Reference no: EM13786514

Q1 Draw an ORM diagram for Customer.

Assume the following constraints: Every Customer must have a unique name, which is a value object. Customers are identified by Customer number, a Character array of size 3. Note: This is a SQL data type denoted by : Char(3). The Location is mandatory, is a value object and may be simply a string, Varchar(20). Annual sales is a Decimal( 5,2) Note: this is a SQL data type that makes space for 5 digits, with 2 to the right of the decimal point. Annual sales are scaled by millions, for example, 3.6 means 3.6 million in dollar sales. ( You may leave this data scaled, as is).

Q2 Draw an ORM diagram for Item.

Item code is unique. every Item must have a title, category, quantity on hand. price is optional

You will need an enumeration for the Categories, and so indicate that on the ORM diagram.

Q3 Draw an ORM diagram for Invoice

Hint: remember to combine semantic domains.

Q4 Draw an ORM diagram for LineItemInvoice. Note, this diagram should be connected to the previous diagrams. You will need a nested object. Note: UnitPrice is optional while the other objects are required.

Q5
Create a database, ItemDB, and then create a table, call it Item. Insert just the first two rows of the data use case Item table.

Reference no: EM13786514

Questions Cloud

Owners equity paper : Prepare a 700- to 1,050-word response to the following questions:

Write an essay about the book omnivores dilemma : Write an essay about The book "Omnivore's Dilemma". What is one major practice you can undertake to eat in a more sustainable (start / begin ) or healthy way?

Health care systems around the world : Provide at least two examples of how this country's system compares to the health care system in the United States.

Obesity in the u.s. : Macroeconomic studies would be more interested in the trend in overweight and obesity in the U.S. and other OECD countries rather than the percent of public spending on health care.

Draw an orm diagram for lineiteminvoice : Draw an ORM diagram for LineItemInvoice. Note, this diagram should be connected to the previous diagrams. You will need a nested object.

What can cause the demand for a resource to shift : What can cause the demand for a resource to shift - Why does the division of resource earnings into economic rent and opportunity costs depend on the resource owner's elasticity of supply?

How does the relationship-based model foster an infants : How does the relationship-based model foster an infants' and toddlers' sense of well-being, competence and quality of life?

Functions of the american institute of cpa : Discuss the key functions of the American Institute of CPAs (AICPA). Has the establishment of PCAOB change any of the key functions if AICPA? Elaborate.

Analyze the decision making process and its ramifications : In this discussion question, provide a different example of a decision that you have observed in your career or you have heard about that fits this pattern. Briefly provide a background to provide context to the reader, and then analyze the decisi..

User Account

All Pages