Draw an er diagram with primary key for a farm, Database Management System

Assignment Help:

Draw an ER diagram that represents the information described below. Show all entity sets, relationship sets, primary keys, and the mapping cardinality of the relationship sets.

"Farmers own one or more sections of land, on which one or many types of grain (e.g., canola, rye, wheat, etc.) may be grown. The grain type can be uniquely identified by its grain ID. As each land section is owned by a single farmer, the farmer knows the amount of each type of grain (measured in tonnes) that is grown in each land section. Based on this information, the farmer can compute the total amount of grains grown in each land section. Each farmer has a name (consists of first name, middle initial, and last name) as well as a unique farmer ID, and may have several contact phone numbers.

When the grains are harvested, each farmer makes a contract to sell some of his grain to a specific grain pool (distribution centre). There are many pools, but each pool handles only one specific type of grain. The price per tonne is constant for each individual pool. There may be multiple pools handling the same type of grain. Normally, a farmer has a contract with a specific pool for a specific amount of a specific type of grain handled by that pool. However, a farmer may have contracts with many pools. Each pool then contracts with a business to sell a specific quantity of grain to that business at an agreed-upon price. This price may vary from contract to contract. A pool may have any number of contracts with any number of businesses, including multiple contracts with the same business. Each pool must maintain the total amount of grain that it has purchased from all of its farmers and the total amount of grain that it has contracted to sell."

Hint: For this question, you may assume the following:

(a) Each land section can be uniquely identified by its section ID. Given a section ID, one can easily find the dimension of the land section.

(b)  One or many types of grain may be grown on the same land section, and the same type of grain may be grown on different land sections.

(c)  Given a grain ID, one can identify the name of the grain type (e.g., canola, rye, wheat, etc.).

(d)  A grain pool (distribution centre) can be uniquely identified by its pool ID.

(e)  Several farmers may have contracts with the same pool.

(f)  A business can be uniquely identified by its business ID.


Related Discussions:- Draw an er diagram with primary key for a farm

BCA, Ask qu. Write a XML with database with book details (Book ID, Title, A...

Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#

Create the database in oracle using ddl, The Assessment page has a link to ...

The Assessment page has a link to download a conceptual model, and a list of data. You are to map this conceptual model, and create the database in Oracle using your own DDL.  T

State the definition of association, State the definition of association ...

State the definition of association An association is a structural relationship which specifies that objects of one thing are connected with objects of another. In UML, asso

Hangman, a method named WonGame that checks each letter in the word is matc...

a method named WonGame that checks each letter in the word is matched by its label

What is stored procedure, What is Stored Procedure? A stored procedure ...

What is Stored Procedure? A stored procedure is a named group of SQL statements that have been previously formed and kept in the server database. Stored procedures accept input

What is a candidate key, What is a candidate key? Minimal super keys ar...

What is a candidate key? Minimal super keys are known as candidate keys.

Need for distributed database systems, Need For Distributed Database System...

Need For Distributed Database Systems A distributed database is a set of database kept on multiple computers that appears to applications as a one database. As a result, an app

Define assertions in sql, Define Assertions in SQL a. An assertion is a...

Define Assertions in SQL a. An assertion is a predicate that is expressing a condition we wish the database to always satisfy.  b. Domain constraints, functional dependency

Determine candidate and primary key, A video rental company has several bra...

A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

Describe the capabilities offered via mysql client apis, Describe the capab...

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

Write Your Message!

Captcha
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