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
What is called a query -execution engine? The query implementation engine takes a query evaluation plan, implements that plan, and returns the answers to the query.

A Relation Schema represented by R(A1, A2, ..., An) is made up of the relation name the list of attributes and R Ai that it contains. A relation is described as a set of tuples

File Organisation In Dbms Introduction Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:


What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

Package classes and associations into models  Programs are made of separate physical units which could be edited, imported, complied or otherwise manipulated. The careful part

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)

Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin

Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.