Produce a logical database design for pharma, Database Management System

Assignment Help:

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

Multi-key file organisation, Multi-Key File Organisation In this part, ...

Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi

What are stand-alone procedures, What are stand-alone procedures? Proce...

What are stand-alone procedures? Procedures that are not part of a package are called as stand-alone because they independently defined. A good example of a stand-alone procedu

Tour Operator Agency Database , #A multinational tour operator agency has g...

#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

A basic model of database access control, A basic model of Database Access ...

A basic model of Database Access Control Models of database access control have grown out of previous work on protection in operating systems. Let us talk about one simple mode

Relational schema, crete a data base relationship model Entity: ...

crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;

Who will teach, Do you have experts of the dbms

Do you have experts of the dbms

Define atomicity and aggregation, Atomicity : Either all functions are lai...

Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions

Create a new service-based database, In this assignment, you will create a ...

In this assignment, you will create a program that works with multiple tables. In this assignment, you will work with the factory and sales tables. 1. Create a new project nam

What is known as fudge factor, What is known as fudge factor? The numbe...

What is known as fudge factor? The number of partitions is enhanced by a small value called the fudge factor, which is usually 20 percent of the number of hash partitions compu

Views-data control, Views A view is like a window by which data from ta...

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages