Produce a logical database design for pharma, Database Management System

Using a database design approach of your choice, produce a logical design for Pharma.

1) Your answer must consist of ONE the following:

  • An entity-relationship (ER) diagram and its mapping into a set of relations. The ER diagram should show all relevant entity types, relationship types, attributes, keys, and structural constraints. For each relation, you should appropriately identify primary keys as well as foreign keys (if applicable).
  • A set of normalised relations (in 3rd normal form). You should make clear how the normalisation process has been carried out, and the reasoning employed, in particular quoting evidence to support the decisions made.

2) You must provide a complete data dictionary.

(B) Based on your logical design from Part 2 (A) and the information available in the scenario, produce an SQL script file using Oracle 10g.

Posted Date: 2/22/2013 8:24:50 AM | Location : United States







Related Discussions:- Produce a logical database design for pharma, Assignment Help, Ask Question on Produce a logical database design for pharma, Get Answer, Expert's Help, Produce a logical database design for pharma Discussions

Write discussion on Produce a logical database design for pharma
Your posts are moderated
Related Questions
Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

What is Hierarchical DBMS In HDBMS, data is structured in a tree like manner. There is a parent-child relationship between data items and the data model is very suitable for re

various techniques of hashing?

Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

Can you help me with the following: Drop statements for all objects in the lab project. Create statements for all objects of the lab project Create indexes for foreign keys Cre

Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies.  Determine the normal form of this table.  Remember that the normal form is the HIGHE

Give two profit of Reuse of Code. Reusing the implementation . Place existing class directly inside a new class. The new class can be made up of any number and type of the oth

prototype of a distributed information system for a national car part retail outlet chain.