ITD320 UNIT 1 IP

ITD320 UNIT 1 IP - Relational Database Management System...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Relational Database Management System Implementation Three Specify Relational Database Relationship Three Specify Relational Database Relationship Dionne Jordan 02-14-10 American Intercontinental University
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Relational Database Management System Implementation Abstract This is a look at three specify relationship that’s connected in a relational database and how it relates to everyday situation we encounter. We will describe the three types of relationship and explain each example. We will name the attributes and entities, as well as select the primary and foreign key.
Background image of page 2
Relational Database Management System Implementation Three Specify Relational Database Relationship Relationships in a relational database are important because it establishes a relationship between a pair of tables that are logically related. For example Employee EmpID EmpFirst Name EmpLast Name Other field 2001 Renee White 2002 John Smith 2003 James Thomas Laptops EmpID LaptopID Checkout Date 2002 100 2-1-10 2003 101 2-10-10 2001 102 2-12-10 The relationship exists in the pair of table by the employee’s ID. Employees can checkout a laptop to borrow during the time their personal laptop
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/04/2011 for the course ITD 320 taught by Professor Mr during the Spring '10 term at AIU Online.

Page1 / 6

ITD320 UNIT 1 IP - Relational Database Management System...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online