Work Database.

Your first assignment is to develop a structure of a database to keep the following information:
  • Supplier name,
  • city where this supplier is located,
  • parts the supplier is supplying,
  • status of the supplier (an integer number between 1 and 100),
  • part name, color,
  • weight in pounds,
  • city where the part is built,
  • part price,
  • what supplier supplies the part and how many of them,
  • project name,
  • city where the project is located,
  • name of the project,
  • what parts this project consumes,
  • what supplier supplies for the project,
  • how many of the specific parts project consumes

    You need to complete these steps:

  • build an Entity-Relationship model
  • fill the ER model with attributes
  • state all functional dependencies
  • create a table structure corresponding to your ER model
  • normalize all your tables
  • write the final tables
  • create the tables using your Oracle account
  • insert testing records in your tables