Reference no: EM13949077
1.Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD.
a). A customer must own at least one car to be in the system. The number of cars can not exceed five cars per customer.
b). A car is owned by one and only one customer.
c). A car may generate many maintenance records.
d). Each maintenance record is generated by one and only one car. e). Some cars have not (yet) generated a maintenance procedure.
f). Each maintenance procedure can use many parts but not more than three parts per procedure.
g). A part may be used in many maintenance records.
2. Use MS Visio to draw an entity-relationship diagram (ERD) for the JustLee Book database (reference the structure of the database in Figure in the Ppt presentation attached).
Draw a fully-labeled ERD that includes entities, labeled relationships (indicate whether each relationship is mandatory or optional), primary keys, foreign keys, and cardinalities. Follow the format (Crow's Foot notation) and naming conventions .
Attachment:- Summary.zip
|
Both machines will be depreciated on a straight-line basis
: Vandalay Industries is considering the purchase of a new machine for the production of latex. Machine A costs $3,078,000 and will last for six years. Variable costs are 30 percent of sales, and fixed costs are $220,000 per year. The required return i..
|
|
What is the current value of operations-terminal value
: Corporate Valuation Ishita Corp has never paid a dividend. Free cash flow is projected to follow the timeline below. After the third year, FCF is expected to grow at 8% annually. The WACC is 13%. $M Year 1 2 3 -10 20 80 What is Ishita's Terminal Valu..
|
|
Representing the binary number
: Design a circuit with a 4-bit input representing the binary number A3A2A1A0. The output should be 1 if the input value is divisible by 3. Assume that the circuit is to be used only for the digits 0 through 9 (thus, values for 10 to 15 can be don't..
|
|
Decided to bid on the contract-what bid price
: Dahlia Enterprises needs someone to supply it with 122,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost you $890,000 to install the equipment n..
|
|
Draw a fully-labeled erd that includes entities
: Draw a fully-labeled ERD that includes entities, labeled relationships (indicate whether each relationship is mandatory or optional), primary keys, foreign keys, and cardinalities. Follow the format (Crow's Foot notation) and naming conventions.
|
|
Find the monthly mortgage including tax and insurance
: Find the monthly mortgage including tax and insurance
|
|
What regional patterns mark off the 50 states
: How different are the rates of violent crime and rates of crime against property across the 50 states? How are the rates of crime related to spending on criminal justice?
|
|
Function defined in the truth table
: 1. Design a combinational logic circuit which will accept a 4-bit binary number and if the number is even, divide it by 210 and produce the binary result; if the number is odd, multiply it by 210 and produce the binary result. 2. a. Fill in the Ka..
|
|
What is the cost of jobs sold in june
: What is the ending balance of Work in Process on June 30? What is the cost of jobs sold in June? Prepare simple job-order cost sheets for each of the five jobs in process during June.
|