Lab%208%20-%20Database%20Implementation

Lab%208%20-%20Database%20Implementation - LAB 8 DATABASE...

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

View Full Document Right Arrow Icon
DATABASE IMPLEMENTATION LAB 8
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 GOAL OF DATABASE  IMPLEMENTATION Take a well-designed ERD. Implement it in a database: Use db-specific data types. Take into account db-specifics. Some DBMSs support Cascade Delete and Update. DBMSs offer varying implementation of auto-increment fields. Some DBMSs offer options concerning how data is physically filed on  the hard drive. Select appropriate indexes.
Background image of page 2
3 MICROSOFT ACCESS DATABASES Good tool for: Information systems that serve a single person. Small workgroup database (25 or fewer simultaneous users). Low-traffic website.
Background image of page 3

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

View Full DocumentRight Arrow Icon
RECOMMENDED NAMING CONVENTIONS FOR  TABLE SETUP IN ACCESS Keep names short, but long enough to be descriptive. Do not include spaces in table or field names - just capitalize the first  letter of each word.  Avoid the use of symbols, such as #. Avoid the Access and SQL reserved words (such as Order, Select, or  Case) and punctuation marks. Be consistent in use of abbreviations. Avoid generic field names (ID, Date). Consider naming primary key and foreign key fields consistently so  they have the same name in both tables. Consider naming all their tables beginning with tbl, all their queries  beginning with qry, etc. Consider naming all fields beginning with an abbreviation of the data 
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

Lab%208%20-%20Database%20Implementation - LAB 8 DATABASE...

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

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