Data Management and Development Notes

Com 123 234 9805 234 green daisy dgreenneartscom

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0123456 Hewic David dhewic 7890123 Sana Vik vsana … … … … Fields Records Rela9onal database model •  Primary Keys –  Each table must include one field (or set of fields) that uniquely iden9fies each record •  Example: The Student ID field •  The DBMS will ensure that there is no duplica9on allowed in the primary key field •  A composite key is when the combina9on of two fields is a unique iden9fier Rela9onal database model •  Foreign Keys –  We “link” tables by pu_ng the primary key of one table as a field in another table –  In the second table, this field is called a foreign Key Rela9onal Database Model •  En9ty Integrity –  All records must be uniquely iden9fied (no nulls or duplicates) •  Referen9al Integrity –  Foreign key references must match a primary key in the referenced table Rela9onal database model •  Jay is an agent for ar9sts. •  Jay wants to be able to keep track all of his ar9sts and their pain9ngs Rela9onal database model Table Name: Ar(st Ar(st ID LName FName Email Phone 123 Brown Rose [email protected] 123- 234- 9805 234 Green Daisy dgreen@finearts.com 234- 567- 8901 345 Black Violet [email protected] 234- 432- 1098 Table Name: Pain(ng Pain(ng ID Title Medium Ar(st ID 56786 Linear Thoughts oil 123 34543 Regression Blues water color 234 23443 Mean Mode in Red oil 123 78987 Grey Simula9ons oil 345 56789 Models in Repose acrylic 234 54432 A Series in Time charcoal 123 Rela9onal database model Table Name: Ar(st Ar(st ID LName FName Email Phone 123 Brown Rose [email protected] 123- 234- 9805 234 Green Daisy dgreen@finearts.com 234- 567- 8901 345 Black Violet [email protected] 234- 432- 1098 Table Name: Pain(ng Pain(ng ID Title Medium Ar(st ID 56786 Linear Thoughts oil 123 34543 Regression Blues water color 234 23443 Mean Mode in Red oil 123 78987 Grey Simula9ons oil 345 56789 Models in Rep...
View Full Document

This document was uploaded on 02/14/2014.

Ask a homework question - tutors are online