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.

Related Discussions:- Produce a logical database design for pharma

Explain saving derived attributes to avoid re-computation, Saving Derived A...

Saving Derived Attributes to Avoid Re-computation As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

BMIS 351, Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work...

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

Primary interface between a visual basic application, Question (a) Visu...

Question (a) Visual Basic is governed by an event processor. Explain the meaning of this phrase. (b) Differentiate between an general procedure and event procedure. (c)

ER diagram, Explain the conventions (relationships) for displaying an ER sc...

Explain the conventions (relationships) for displaying an ER schema as an ER diagram.

Is siteground database over limit, I am using Siteground. And my databas...

I am using Siteground. And my database is full of limit so need someone who reduces the data which no need. This is very simple and simple task. Skills required are Databa

File Management Principles, What are the requirements to ensure the objecti...

What are the requirements to ensure the objectives of file management principle is realized?

Example of alter table command, Example - ALTER TABLE emp MODIFY (empno NUM...

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

Determine the un-normalized form, Un-Normalized Form (UNF) If a table h...

Un-Normalized Form (UNF) If a table having non-atomic values at every row, it is said to be in UNF. An atomic value is something that cannot be further decomposed. A non-atomic

Project, write a database program for concurrency transaction in a bank

write a database program for concurrency transaction in a bank

Related Rates, All edges of a cube are expanding at a rate of 6 centimeters...

All edges of a cube are expanding at a rate of 6 centimeters per second. How fast is the surface area changing when each edge is (a) 2 centimeters and (b) 10 centimeters?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages