Data Management and Development Notes

Loaned to art galleries what are the en99es that jay

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: ose 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 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 Repose acrylic 234 54432 A Series in Time charcoal 123 En9ty Rela9onship Diagrams En99es – a person, place, event or thing about which we intend to collect data Rela9onships – one- to- one, one- to- many, many- to- many Acributes – The characteris9cs of the en9ty that we want to record En9ty Rela9onship Diagrams •  Jay arranges for his ar9sts’ pain9ngs to be loaned to art galleries –  What are the en99es that Jay needs to keep data on? –  Describe the rela9onships between these en99es? –  Construct an en9ty rela9onship diagram 22 En9ty Rela9onship Diagram Ar9st 1 creates 1:M M Pain9ng M displays 1 Gallery 1:M 23 Tables and Key Fields 24 En9ty Rela9onship Diagrams Many- to- Many Rela9onships Student M takes M Course Many-to-many relationships are broken down to two one-to-many relationships Student 1 has M Enrollment M for 1 Course 26 STUDENT table StudNum StudLastName 4978567 Alpha 4978568 Bravo 4968569 Charles 4965237 Delta 4960238 Echo 4955239 Foxtrot 4950240...
View Full Document

This document was uploaded on 02/14/2014.

Ask a homework question - tutors are online