Create modified Database tables for T3MCE

Zhilong’s documentation for  
Term III Massage Clinic Evaluation (called T3MCE is used suffix of tables by developer ) <= at modules level
                               Module (1) Safety <=  at certain module level  as a module_id (mdle00001) in modules_T3MCE as a parent table in which mapping to its child table themodule_T3MCE 
Demonstrate Hygiene & Universal Precautions (1.2g & 3.1c):  <= at item level  as a  item_id(item00001)  in the module_T3MCE table.  Another part is a (1.2g & 3.1c):  as a item_code in the same table for searching like as item_code(‘(1.2g & 3.1c): ‘) 

	Demonstrate standard hygiene practices* <= at subitem level, as a sitem_id in subitem table. If the item has subitems, sitem_subitems attribute should have a number of subitem(s); if not so, its value of the attribute is 0.
Pattern is sitem_id attribute(value) known as sitem_id(sitem0001) 
o	Washing hands etc.  <= at ssubitem level as a ssitem_id in ssubitem table. Its principle is the same as its parent’s item.  Its form is ssitem_id attribute(value) known as ssitem_id(ssitem001)
	Maintain grooming, dress and hygiene appropriate to the practice setting* <= as the same way to define, just different sitem_id given like as sitem_id(sitem0002)
o	Uniform, shoes, nametag etc. <= ssitem_id (ssitem001)
	Apply standard precautions for infection control* <= sitem_id (sitem0003) 
o	Washing table, faceplate, clean sheets etc. <= ssitem_id (ssitem001)

	Excellent     Good    Satisfactory   Poor    Inadequate <= at different evaluation levels, as a sitem_grade attribute sitem_grade or its child ssitem_grade if having in the subitem table or ssubitem table. Their value of grades should be posted as original pattern 
Comments: <= as a item’s comment attribute in themodule table

Supervised Level  <= the vaule of comment attribute

Date <= finished_date___ Student_<= can get it from student_id___ supervisor <= can get it supervisor_id ______________________
Zhilong’s comments :

1.	For more details specifically between client module and corresponding database attributes, tables and constraints, you can reference my new SQL script, code and ERD.  
2.	For an informal description of the client module pattern can be transformed database table and related attributes regarding principle of database modeling with ERD to different types of entities shown as attached SQL script in the sources code part. The part of other modules are probably the most similar this pattern with transformative mechanism in the first module and its child items described. Please note that words with red color comments to explain how to transform between client evaluation form and database tables, attributes. I applied rows constraints in referential integration with parent entity and its weak entity in a recursive way to create RDB tables from client evaluation modules. And another aspect of design, I think that it is necessary to use primary keys and its corresponding foreign keys in student_id and finished_date attributes to each row. Although it could be a little bit of denormalization, and needs a bit more space, it can take many advantages of writing sql statements become much simple and easier. Moreover, it also can identify the same records except each different finished date only to be stored in the tables. It can be used for statistic certain student grades from those historical grades to create graph available to meet client request. 

3.	For other modules of the two documents shown as <Mss 3041 Teacher Student OSCE Background Information-Final 2013.docx> and <Mss NEW 3030 & 3040 Treatment OSCE  2013 copy.docx > client provided, I try to do them as well recently. All of tables and diagram are based on Oracle 11g express version and Oracle SQL Developer. As you know, we are using Microsoft SQL server for our ASP.NET. This changing made would be very small, just being  transform from number datatype  to decimal datatype and data format at all before load them to MS SQL server.
Demonstrate Safe & Comfortable Treatment Environment (3.1b):

	Establish and maintain a safe and comfortable environment* 
	Ensure setting and equipment meet patient needs 
	Maintain equipment in proper working order* 
o	Clean and well organized working space
o	Proper table type, stool, chair and faceplate etc.
o	Working thermophore, stethoscope, BP cuff & goniometer
o	Pillow, blankets, sheets and bolsters

	Excellent      Good    Satisfactory    Poor    Inadequate
Comments: 

Assisted Level

Date_________ Student_________________________ Supervisor________________________