3024-Chap8 - 8. CONCEPTUAL DATA MODELING: FUNDAMENTAL...

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

View Full Document Right Arrow Icon
8. CONCEPTUAL DATA MODELING: FUNDAMENTAL CONCEPTS First step in designing a database: specifying conceptual schema. This is a critical step. Without an accurate conceptual chema resulting information system may not meet our schema, resulting information system may not meet our needs or even function properly. • Conceptual schema is “blueprint” for information system design. 2010 John P. Shewchuk ISE 3024 Course Notes 8 – 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
et’s first describe fundamental data modeling concepts Let s first describe fundamental data modeling concepts, so that we know how to specify a conceptual schema. We will do this in the context of an ‘old-fashioned’ bookstore. We’ll then see how we can use the discovery process to develop conceptual schema. 2010 John P. Shewchuk ISE 3024 Course Notes 8 – 2
Background image of page 2
8.1 Entities, Entity Classes, Attributes and Attribute Values ntity some particular object of interest to us Entity = some particular object of interest to us. • e.g., a book having ISBN 0-13-056517-2 John Smith (a customer) Thomson International helf s4 (a book supplier) shelf at Anna’s Books which holds shelf s4 (a shelf at Anna s Books which holds books) 2010 John P. Shewchuk ISE 3024 Course Notes 8 – 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
ntity Class collection of similar entities Entity Class = collection of similar entities e.g., Book entity class Customer entity class Supplier entity class Shelf entity class We can also think of entities as instances of a given class . g 2010 John P. Shewchuk ISE 3024 Course Notes 8 – 4
Background image of page 4
ttributes = characteristics used to efine imilar entities Attributes characteristics used to define similar entities. e.g., Book entities defined by ISBN,title,author, publisher,year,price,bookId Customer : lastname , firstname , address Supplier : name,state,phone,rating Shelf : shelfId 2010 John P. Shewchuk ISE 3024 Course Notes 8 – 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
ttribute Values = values for attributes for a articular Attribute Values values for attributes for a particular entity. e.g., Book entities: book d titl th bli h ISBN i 12 Star Wars: Jedi Trial Dan Cragg Random House 0-3454-6115-0 2005 $6.99 27 Band of Brothers Stephen Ambrose Simon & Schuster 0-7432-2454-X 2001 $17.82 i l f F i d B i h l lPb l ih i 402 26 995 7 99 Id title author publisher ISBN year price 9 Circle of Friends Maeve Binchy Dell Publishing 0-4402-1126-3 1995 $7.99 37 Message In A Bottle Nicholas Sparks Time Warner 1-5948-3636-1 1999 $7.50 23 The Long Road Home Danielle Steel Dell Publishing 0-4402-4344-0 2006 $14.99 4 Star Wars: Jedi Trial Dan Cragg Random House 0-3454-6115-0 2005 6.99 gg $ 18 Beyond Valor Patrick O’Donnell Simon & Schuster 0-6848-7385-0 2001 $8.99 32 Curious George Margret and H.A. Rey Houghton Mifflin 0-3951-5023-X 1973 $14.00 17 Beyond Valor Patrick O’Donnell Simon & Schuster 0-6848-7385-0 2001 $8.99 2010 John P. Shewchuk ISE 3024 Course Notes 8 – 6
Background image of page 6
ustomer ntities: Customer entities: address lastName firstName street city state zip Smith John 214 Church St. Blacksburg VA 24073 avis iane 85 Clay St lacksburg A 4073 Davis Diane 185 Clay St. Blacksburg 24073 O’Keefe Patrick 35 Cambria St. Christiansburg 24061 Smith John 24 Range Road Radford 24141 Morgan Leslie 240 Kent St., Apt. 27 Christiansburg 24061
Background image of page 7

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

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

This note was uploaded on 02/14/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 46

3024-Chap8 - 8. CONCEPTUAL DATA MODELING: FUNDAMENTAL...

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

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