Convert the erd into its relevant relational schema, Database Management System

Assignment Help:

Question:

Describe briefly the three parts of the Relational Model.

(a) The term integrity refers to the accuracy or correctness of the data in the database. Define the following terms:

i) Domain Integrity
ii) Entity Integrity
iii) Referential Integrity

(b) Given the following business rules for a situation:

1. Each vendor can supply many parts to any number of warehouses, but need not supply any parts. The identifier for vendor is vendor_id and other attributes includes: vendor_name, address, tel. The identifier for part is part_no other attributes includes: part_desc, QOH and Unit Price. The identifier for Warehouse is warehouse_no and other attributes include location.

2. Each Part can be supplied by any number of vendors to more than one warehouse, but each part must be supplied by at least one vendor to a warehouse.

3. Each warehouse can be supplied with any number of parts from more than one vendor, but each warehouse must be supplied with at least one part.

4. The attribute for the supplies relationship are: shipping mode and unit_cost.

(i) Draw an ERD from the above scenario. You have to include the minimum and maximum cardinalities and also show whether it is an optional or mandatory relationship from the above scenario.

(ii) Convert the above ERD into its relevant Relational Schema.


Related Discussions:- Convert the erd into its relevant relational schema

Create a e-r diagram, Information about films holds information about movie...

Information about films holds information about movies, stars and studios. Movies have a title, year of production, length and the film type. Stars have a name and address. Studi

Explain the timestamp ordering protocol, Timestamp Ordering Protocol A ...

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

Fragmentation-design of distributed databases, Fragmentation: It is defini...

Fragmentation: It is definite as partitioning of a relation into various fragments.Every fragment can be stored at a dissimilar site.

What is difference between truncate and delete, What is difference between ...

What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea

Data Analysis, A buyer for a large department store chain must place orders...

A buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. In par

What is inheritance, What is inheritance? Define it in detail?  Inheri...

What is inheritance? Define it in detail?  Inheritance Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then i

For known, What are the function of DBA?

What are the function of DBA?

Need web-based database, Our company hires independent contractors to insta...

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

Why like predicate used for, Why Like predicate used for? LIKE predicat...

Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

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