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
E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database

#question. Draw a picture of a moving source and the waves surrounding it according to what you observed in this experiment. How does the spacing of the wave-fronts in front of the

Provide Examples of different types of Time and Date formats.  It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Define hot swapping? Hot swapping permits the removal of faulty disks and changes it by new ones without turning power off. Hot swapping decreases the mean time to repair.

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible? Yes. Because Transact-SQL supports recursion, you can write kept proced