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.