Drawing entities and relationship using crow-s foot notation

Assignment Help Database Management System
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.

Reference no: EM1347000

Questions Cloud

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.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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