TIL

TIL

  • Docs
  • Contact
  • Feedback
  • Contribute

›Week 4

Getting Started

  • Introduction

Principles of Programming Languages

    Week 3

    • Pattern Matching and Recursive Data Types

    Week 8

    • Monads

Introduction to Databases

    Week 3

    • Cinema Database

    Week 4

    • Pine Valley Furniture
    • Pine Valley Furniture - Solution

    Week 5

    • ERD to Shorthand Conversions
    • ERD to Shorthand Conversions - Solution

    Week 6

    • Normalizations
    • Normalizations - Solutions

    Week 7

    • Other Normal Forms
    • Other Normal Forms - Solutions

    Week 8

    • SQL Introduction

    Week 9

    • More SQL

    Week 10

    • Joins and Subqueries

    Week 11

    • Functions, Procedures, Triggers and Embedded SQL

    Week 12

    • Prepared SQL Statements
Edit

Pine Valley Furniture

Draw the ER diagram for Pine Valley Furniture (PVF) on paper

Pine Valley Furniture produces a variety of furniture. In this company, each customer places any number of orders in which any number of order lines are written. Each order is billed on one invoice. Each product that is produced by PVF has any number of order lines. The company requires to store customers’ name, address and postal code.

PVF also has salespeople who each serve in different locations. They have a name, contact number and a fax number for customers that may want to do business with them.

PVF has a number of product lines for their furniture. Each product line has a name and every piece of furniture belongs to exactly one product line. PVF wants to keep information on the product description, the product finish and the standard price of each product. Products are made from a multitude of raw materials which the company also wants to keep track of. This information includes the name of the material, standard cost and unit of measure (square inches, etc.). Raw materials are also supplied by many different vendors. They have a name and address to supply from.

All products sold by Pine Valley Furniture are produced in work centers, which are located at an address. Employees are situated in these work centers and may have various skills like assembling and cleaning the products. PVF wants to keep track of their names and addresses. Employees may have a supervisor, but a supervisor doesn’t have to supervise anyone.

Last updated on 1/4/2019
← Cinema DatabasePine Valley Furniture - Solution →
TIL
Docs
Getting StartedPrinciples of Programming Languages (C24)Introduction to Databases (C43)
Community
PiazzaQuercus
More
GitHubStar
Facebook Open Source
Copyright © 2019 Rakin Uddin