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
comparison of oracle RDBMS with MySQL

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

what do you mean by consistency in rdbms?

Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

Describe sequential file organization.  Explain the rules for (i)  Inserting a new record. (ii)  Deleting an existing record.          Ans:A sequential f

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

management information system based on functional organisation

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

Control as Concurrent Tasks The expression control as simultaneous task means applying control for those events of object which can happen simultaneously. An object can be imp