Database design in third normal form, Database Management System

The following data are required to be stored by a family physician.

Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate

A family can have several patients. A patient belongs to a single family. Each service has a code and a fee. A patient can get only one service on a given date. Show the database design in third normal form for the above data.

 

Posted Date: 4/6/2013 5:17:08 AM | Location : United States







Related Discussions:- Database design in third normal form, Assignment Help, Ask Question on Database design in third normal form, Get Answer, Expert's Help, Database design in third normal form Discussions

Write discussion on Database design in third normal form
Your posts are moderated
Related Questions
Define Boyce codd normal form A relation schema R is in BCNF with respect to a set F of functional dependencies if, for all functional dependencies in F + of the form.α ->β.

Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d

Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

Explain pipelining.        Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,

Do you have experts of the dbms

statical data

Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship