Class08-09_MidTerm_Misc_Spring_2009

Class08-09_MidTerm_Misc_Spring_2009 - BCIS 4620...

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

View Full Document Right Arrow Icon
BCIS 4620 INTRODUCTION TO DATABASE PROCESSING Class 9 (Optional) Spring 2009 Dr. Jack D. Becker
Background image of page 1

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

View Full DocumentRight Arrow Icon
CLASS 9 MIDTERM EXAMINATION & Relational Database Implementation Announcements Review Mid-Term EXAM Relational Implementation -- Central Cities HC Homework #6 Preview (DB Design; CREATES) Homework #7 Preview (DB Loads; Reports)
Background image of page 2
SQL/DS NX Tips TableDesigner Version 1.0 tip TableDesigner creates extra keys to guarantee uniqueness; some of these may be redundant and unnecessary, if we concatenate one or more attributes of the relation. VARCHAR is the correct datatype for SQL/DS TableDesigner Version 1.0 may be used to create ACCESS databases with corresponding ERDs Use the Database option when your SO model is ready!
Background image of page 3

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

View Full DocumentRight Arrow Icon
Homework #6 (Review) Final Project Case Discussion -- DB Design TableDesigner Version 1.0 SOM Grading form Objects, attributes, cardinalities, SOLs ERD Grading form Entities, properties, relationships
Background image of page 4
Homework #6 (cont.) TableDesigner Version 1.0 Generates:
Background image of page 5

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

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

This note was uploaded on 03/09/2011 for the course BCIS 4620 taught by Professor Staff during the Spring '08 term at North Texas.

Page1 / 14

Class08-09_MidTerm_Misc_Spring_2009 - BCIS 4620...

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

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