Erd Diagram & Normalization

User Generated

Fnen Unlng

Engineering

Description

Please do check the attachment file before you bid. Thanks.


Assignment

Unformatted Attachment Preview

York University Assignment #1 ITEC 3220A Fall 2015 Due Date: October 6th, 2015 at 11:00AM 20 points Notes:    All assignments are individual work. No group collaboration is allowed. The cover page of each assignment should include your last name, first name, and your student number. Please submit your assignment by depositing it in the drop-box number 27. The box is located in the TEL building, third floor, near the elevators. Part I. ERD Diagram (10 points) Draw an ERD diagram based on the Chen model for a database to support the basic operations of “Frank River Jewelry”. Specify:  Entity sets, their attributes, and primary keys;  Relationship sets and their descriptive attributes (if such exist);  Connectivities and cardinalities;  Decompose all M-M relationships, if any;  If found, replace any multivalued attributes and composite attributes appropriately. Each piece of jewelry for sale is assigned a unique number, and is described by the name, sale price and a style. Each piece of jewelry can be made from one or more material, e.g. white gold and diamond. The same material can be used to make many pieces of jewelry. The materials used and their amount for each piece must be recorded in the database. Materials are described by material code, title and feature. A material can be a mixture of other materials. Then it is necessary to record the composition of the material including the percentage of each mixed material. The same material can be used to make many kinds of mixtures. 1 For each piece of jewelry it is necessary to record the artist who created the piece of art. Information about artists is to be recorded in the database. It includes artist ID, name, address and phone number. One artist can create many pieces of jewelry. Each piece of jewelry can be only made by one artist. Part II. Normalization (10 points) Using the conceptual model (ERD) presented below, create a relational schema for the database of a manufacturing company. For each of the relations, indicate the normal form for that relation, if the relation is not in third normal form, decompose it into 3NF. 2 Customer_ID Customer_Nam e CUSTOMER Address 1 1 has RECORD 1 R_ID History submit Order_ID M ORDER Order_Date 1 M Order_Quantity orderline M 1 PRODUCT Product_ID Description 1 Price M produce E_ID M E_Name Skill_ID Skill_Name 1 WORK CENTER 1 M work M 1 EMPLOYEE 1 M W_ID W_Name supervise 3
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Great! 10/10 would recommend using Studypool to help you study.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags