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
What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f

Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

Problem 1 What is a Data Warehouse? Mention its advantages 2 Explain the Top-Down and Bottom-up Data Warehouse development Methodologies 3 What is Data Transformation? Ex

DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b

comparison of oracle RDBMS with MySQL

The primary key is selected from the

Which is the properties of entities? Attributes is the properties of entities.

Define identify relationship? Identifying relationship: An identifying relationship means in which the child table cannot be uniquely recognize without the parent. For exampl

Define the Two Phase Locking Protocol This is a protocol that is used to make sure serializability of transactions. This protocol needs that every transaction issue lock and u