INFO 3240 PHASE II Critique – Spring 2021 *Remarks highlighted in red
above, represent areas that does not appear correct, needed more rigor
(did not meet expectations) or was missing from the deliverable. These
need to be modified before submitting the next deliverable. Remarks
highlighted in blue above, represent basic comments that do not affect the grade, but should be addressed. DB Developer: Tianyang Grade: 50 DB Name: SkiResort (rename to something more descriptive) DB Peer Reviewer: Yicheng ———————————————- PHASE I ————————————————— DB Build: Build script fails on my machine…. I had to delete the DB to run script. File named according to assignment directions. Name and peer reviewer added as comments at the beginning of the build script. Build script used appropriate T-SQL code structure (e.g. IF EXIST, GO), comments, table creation, PK, FK, various constraints and check constraints and appropriate data types. Data loaded (e.g., Bulk load .csv files) without error(s). Script included UNION statement to display tables and rows. Script was executed several times without errors. DB Diagram: Referential integrity appears to be working. At least 20 rows of data (or equivalent) and is proportional. Your DB is normalized. ———————————————- PHASE II ————————————————— ReadMe.txt: Good notes (e.g. easy to follow, logical, and well written), including spell-check and Peer Reviewer’s name. Rebuild Phase I: View.sql: Script runs with appropriate USE/IF/DROP/GO/CREATE statement. Form Function: seems useful and provides creativity beyond what was provided in the class tutorial(s). Form Sub: is well-written, functional and provides creativity beyond what was provided in the class tutorial(s). Comments: Directory structure is clean, files organized and named accordingly. Server name set to localhost. Project has a combination of useful and well-designed forms (one each for detail, grid, and subform). Practical, functional and creative Search form. Aggregations (sum, count, average) used in at least one form. “Code behind” in the forms is clean and well-organized. A keen eye given to formatting ($, alignment of column headings/data, etc.). If the Add option is available, the PK is filled in. The Delete option has been removed from all forms. (Some) heavy lifting was noticed. Overall, your Phase II is considered unacceptable. Please make the needed improvements, then move forward with Phase III. Thanks.
