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 the steps for reduction of er model into relational model?

Describe the static hash file with buckets and chaining and show how insertion, deletion and modification of a record can be performed. In static hash file organization, the wo

Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,

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,

Find out the names of all employees who work for first Bank Corporation from database. SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANYNAME = ‘First Bank Corporation';

1. Determine the set of minimal functional dependencies for the following data. The local bakery, Happy Cakes, needs your help designing a database that will support a kiosk in

how to calculate frequency count of algorithm


How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.