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

Primary and foreign key, Primary Key The primary key is the candidate k...

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi

Information system fundamentals, A full discription of the new, a discripti...

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

Explain the advantages of database management system, Advantages of Databas...

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

ER Diagram, Hi I have got an assignment for making an er diagram for market...

Hi I have got an assignment for making an er diagram for market management software can any budy help me?

Key constraint - relational constraints, This constraint shows that the key...

This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the

What is meant by log-based recovery, What is meant by log-based recovery? ...

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

Hashing, how to implement mid square hashing?

how to implement mid square hashing?

Find names of employees, Consider the relations EMP(ENO,ENAME,AGE,BASIC_S...

Consider the relations EMP(ENO,ENAME,AGE,BASIC_SALARY) WORK_IN(ENO,DNO) DEPT(DNO,DNAME,CITY) Express the following queries in SQL (i) Find names of employees who work in a dep

What are segments in oracle, What are segments in oracle? Segments - Ea...

What are segments in oracle? Segments - Each table has single field of disk space, known as segment, set aside for it in the tablespace. Segments consist of contiguous sections

ER DIAGRAM, draw ER diagram of student entity and course entity where attri...

draw ER diagram of student entity and course entity where attribute of student entity are student roll, student name, student phone and student address and attribute of course enti

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