Class09_NX_Chap09_Kroenke10_Spring2009

Class09_NX_Chap09_Kroenke10_Spring2009 - BCIS 4620...

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

View Full Document Right Arrow Icon
BCIS 4620 INTRODUCTION TO DATABASE PROCESSING Class 9 Spring 2009 Dr. Jack D. Becker 0
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 Relational Database Implementation Announcements Mid-Term Examination Review Preview of Concurrent Processing Considerations Chapter 9K Homework #6 Review (Final Project Design) Homework #7 Preview (DB Loads; Reports) 0
Background image of page 2
CLASS 9 CLASS #9 -- Announcements, misc. ., etc. Class Announcements CISO Mid Term Examination Review Grade distributions Bonus points [12 possible] Scoring procedures used 1.2 ( Bonus factor: xx) times number correct on first 100 2 times number correct on last 6 0
Background image of page 3

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

View Full DocumentRight Arrow Icon
TableDesigner & NX/SQL Tips TableDesigner Version 1.0 tip TableDesigner Version 1.0 creates extra keys to guarantee uniqueness; and some of these may be redundant and unnecessary, if we concatenate one or more attributes of the relation. VARCHAR is the correct datatype for NX/SQL Use TableDesigner to create ACCESS databases with corresponding ERDs Use the Database option when your SO model is ready! IMPORT & EXPORT TIPS 0
Background image of page 4
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 5

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

View Full DocumentRight Arrow Icon
Homework #6 (cont.) TableDesigner Version 1.0 Generates: SQLGen.txt file CREATE TABLE … SQL code automatic generator ACCESS.mdb file Relationship Diagram Entity, Relationship, Attribute (properties) Report RELATION List Summary Report (You type), e.g.: EMP(ENO , FNAME, LNAME, ADDR, foreign_keys , …) Separate file for each table or view (-5 point penalty)
Background image of page 6
Background image of page 7

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

View Full DocumentRight Arrow Icon
Concatenated Primary Keys [TableDesigner]
Background image of page 8
SELECT Statement – WARNING! SELECT can be used to obtain values of specific columns ( PROJECTION ), specific rows ( SELECTION ), or both Basic format: SELECT (column names or *) FROM (table name(s)) [WHERE (conditions)]; NOTE: The ORDER of the Clauses Matters!! If you forgot this Dr. Windsor will jump all over you!
Background image of page 9

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

View Full DocumentRight Arrow Icon
DB APPLICATION IMPLEMENTATION DB Application Implementation Chapter 9K Relational Implementation – Example: Central Cities Health Club Menu Systems 0
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 39

Class09_NX_Chap09_Kroenke10_Spring2009 - BCIS 4620...

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

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