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
write an SQL statement to create the database in MYSQL server

Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap


Adding Redundant Associations for Efficient Access Redundant associations do not add any type of information, therefore during design we should actually examine structure of o

Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.


How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

Should I select imaging software that allows changes? An imaging system should not give features to edit or alter images. Images generally are formed as safe and secure records

explain in detail about time stamp orderting/