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
Explain sorted File with advantages?  Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the

Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

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

i am not clear with the climetic condition of the north indian plain. can u plz explain it for me

want a idea for final year project

Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?  How many levels of SP nesting is possible? Recursion is method of proble

Objectives differentiate DDBMS and conventional DBMS; Describe Network topology for DDBMS; Describe the concepts of horizontal and vertical fragmentation; Descr