Reference no: EM1347000
Q1) These following questions require to you to create entities and their relationship using the Crow's Foot notation suitably. Write out the business rule along with the diagram. If you encounter a many to many relationship, illustrate that first, then the corrected one after that. Indicate the appropriate keys along with the attributes.
a) Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow's name, age (or date of birth), breed and numbered plastic ear tag. The each of the three farmers own many cows and share some of the cows with one another.
b) An art researcher has asked you to design a database to record details of artists and the museum in which their paintings are displayed. For each painting, the researcher wants to know the size of the canvas, year painted, title, and style. The nationality, date of birth and death of each artist must be recorded. For each museum, record details of its location and specialty, if it has one.
c) A hamburger shop makes several types of hamburgers, and the same ingredient can be used with several types of hamburgers. This does not literally mean the same piece of lettuce is used many times, but that lettuce is used with several types of hamburgers.
|
Find out the speed of light in calcite
: A man weighing 730 and a woman weighing 410 have the same momentum. What is the ratio of the man's kinetic energy to that of the woman.
|
|
Elucidate what will happen if oil prices remain in range
: As per to Global Insight, a Massachusetts economics consultancy, elucidate what will happen if oil prices remain in the range of $65 to $70 per barrel for a couple of more months.
|
|
Activity-based costing: hampstead company
: Hampstead company's order entry department has 20 order entry operators. The cost associated with these 20 operators (salaries, fringe benefits, and supervision, as well as occupancy and equipment costs) is $873,600 per year.
|
|
Improving communication and indepedent distribution channels
: List and explain the three possible relationships among perceived value, price and cost ignoring the competition for the present. If you consider the competition, then what is the perceived relationship among value, price and cost
|
|
Drawing entities and relationship using crow-s foot notation
: These following questions require to you to create entities and their relationship using the Crow's Foot notation suitably.
|
|
Product costing- traditional and activity
: Determine total product cost per unit for each product using an activity based costing system. Use the number of units as the cost driver for each activity.
|
|
What is the temperature t of concorde''s skin in flight
: A hunter aims directly at a target (on the same level) 101m away. If the bullet leaves the gun at a velocity of 203m/s, by how much will it miss the target.
|
|
Finding the stock and debt
: Suppose I am a 100% shareholder of Johnson Corporation. At the starting of 2010, My basis in Johnson Corporation stock was $14,000. During 2010, I loaned $20,000 to Johnson Corporation and Johnson Corp. reported a $25,000 ordinary business loss
|
|
Find youngs modulus for the muscle tissue
: A wooden raft has a mass of 65 kg. When empty it floats in water (density 1000 kg/m3) with 41percent of its volume submerged. What mass of sand can be put on the raft without it sinking.
|