Assignment 4 - 6(Resources View Normalization Tutorial This...

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

View Full Document Right Arrow Icon
Course Material: 1. Read Chapter 4 Designing a Database in textbook to get an overview of concepts and terminology. Note examples for General Hardware and Good Reading Bookstore. 2. (Overview) Read Logical Design 1 and Logical Design 2 Notes 3. (Resources) Read ERD-Data Structures Notes for step by step instructions on converting an ERD to a Data Structure. You may wish to print this document as reference material. 4. (Resources) View ERD to Data StructuresTutorial . This PowerPoint presentation describes the process and presents some sample problems with solutions. Most slides contain additional notes and explanation. 5. (Resources) Read Normalization Notes for definitions of normal forms.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6. (Resources) View Normalization Tutorial. This is a PowerPoint presentation. Some additional notes are included with some slides for explanation. Textbook: Page 138 - 140 Summary Questions 3, 4, 8, 9, 11, 12, 13, 14, 17, 18 Page 140, Applying This Chapter, #2. Using the ERD in Figure 4-32, note do not answer question in the textbook answer the following: create the data structures for this ERD. Resolve any relationships with associative entities. For data structures, use the following format: ENTITY (attribute1(pk), attribute2, attribute3(fk), . ..) Use the acronym pk for primary key and fk for foreign key. submit as assignment 4...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online