Items to create: Tables, columns, checks, defaults. Deliveries: Dictionary Datab

Items to create: Tables, columns, checks, defaults.
Deliveries:
Dictionary
Database Diagram
Screen Captures of navigation panel expanded to show Bed column checks and defaults, and Age column (example provided here.
MDF and LDF files
1. Build must match dictionary, and tables must match ERD and RS design.
2. Bed table must have a checks and defaults as stated in narrative.
3. Tables must be connected with proper PKs and FKs.
7. Tables based on associate entities must have proper CPK notation for Key and Index, or use surrogate key.
8. PK of each table must be set to data type INT and Identity seed 1, increment 1.
9. Patient age must be calculated column. Hint for calculation: datediff(year,dob,getdate()).
10. Charges should be money data type, because it is already formatted for 2 decimal places.
11. Hours should be decimal (4,2) data type, so that someone can work fractions of an hour. The 4 indicates total places, the 2 indicates number of places to the right of the decimal. This is also true for the numeric data type.