Ict40115 Certificate Iv In Information Assessment Answers
Requirements for providing data dictionary for tables:
- Each table needs to have enough attributes to cover the case requirements.
- Identify attribute keys– unique keys, primary keys, foreign keys, composite keys, index keys
- Identify attribute types – data type, user defined types, structured types, reference types and user defined functions
- Describe attribute data types and their application
Answer:
The student enters course and requests for a section. The system then verifies the prerequisite of the student. The prerequisite of the student is verified by “referring the student’s on-line transcript of classes completed and grades received.”. Then the next measure by the system is to verify the availability of room in the section. If room is available, then the student is added to the waitlist and the student is sent an enrolment notification.
In the second scenario, if the prerequisite of the student is not clear then a not enrolled notification is sent to the student. In the third scenario, if the student prerequisite is valid and the room is not available then also a not enrolled notification is sent to the student.
Entity Relationship Matrix
|
|
Student |
Course |
Section |
transcript |
Room |
|
Student |
x |
ü |
request |
verify |
available |
|
Course |
x |
prerequisite |
ü |
ü |
done in |
|
Section |
ü |
belongs to |
x |
verify |
x |
|
transcript |
ü |
belongs to |
own |
x |
x |
|
Room |
belongs to |
x |
x |
x |
x |
Table 1: Entity Relationship Matrix
(Source: Created by Author)
Task 3:
|
DATA DICTIONARY FOR ENTITIES |
|
|
| |
|
|
|
|
|
|
|
ENTITY COURSE : |
|
|
|
|
|
Attibute |
Data Type |
Null |
Default |
Constraint/Criteria/Options/Comments |
|
CID |
int(8) |
No |
99999999 |
CONSTRAINT COURSE CHECK |
|
Title |
varchar(50) |
No |
|
INDEXED UNIQUE |
|
ENTITY PREREQ : |
|
|
|
|
|
Attribute |
Data Type |
Null |
Default |
Constraint/Criteria/Options/Comments |
|
PID |
int(8) |
No |
99999999 |
CONSTRAINT PREREQ CHECK (PID>99999999), Primary Key |
|
CID |
int(8) |
No |
99999999 |
Foreign Key (CID) refernces COURSE (CID) |
|
ENTITY SECTION : |
|
|
|
|
|
Attribute |
Data Type |
Null |
Default |
Constraint/Criteria/Options/Comments |
|
sec_ID |
int(4) |
No |
999 |
CONSTRAINT SECTION CHECK (sec_ID>999), Primary Key |
|
CID |
int(8) |
No |
99999999 |
Foreign Key (CID) refernces COURSE (CID) |
|
Faculty |
varchar(30) |
No |
|
INDEXED |
|
R_id |
int(4) |
No |
999 |
CONSTRAINT ROOM CHECK (RID>999), Foreign Key |
|
ENTITY ROOM : |
|
|
|
|
|
Attribute |
Data Type |
Null |
Default |
Constraint/Criteria/Options/Comments |
|
R_id |
int(4) |
No |
9999 |
CONSTRAINT ROOM CHECK (RID>999), Primary Key |
|
available_seat |
int(2) |
No |
99 |
CONSTRAINT SECTION CHECK (sec_ID>15) |
|
available_room |
bit |
No |
|
BOOLEAN |
|
ENTITY STUDENT : |
|
|
|
|
|
Attribute |
Data Type |
Null |
Default |
Constraint/Criteria/Options/Comments |
|
SID |
int(4) |
No |
999 |
CONSTRAINT SECTION CHECK (SID>999), Primary Key |
|
s_name |
varchar(30) |
No |
|
Composite Key |
|
F_name |
varchar(30) |
No |
|
|
|
L_name |
varchar(30) |
No |
|
|
|
Std_address |
|
|
|
Composite Key |
|
street |
varchar(30) |
No |
|
|
|
state |
varchar(30) |
No |
|
|
|
Zipcode |
int(6) |
No |
999999 |
|
|
|
|
|
|
|
|
ENTITY TRANSCRIPT : |
|
|
|
|
|
Attribute |
Data Type |
Null |
Default |
Constraint/Criteria/Options/Comments |
|
TID |
int(10) |
No |
9999999999 |
CONSTRAINT TRANSCRIPTION CHECK (TID>9999999999), Primary Key |
|
T_Name |
varchar(30) |
No |
|
|
|
T_content |
varchar(30) |
No |
|
|
|
T_type |
varchar(30) |
No |
|
|
(Source: Created by Author using MS Visio)
Task 4: ER Diagram and Normalization:
Figure 3: ER Diagram HR SYStem
(Source: Created by Author using MS Visio)
2NF table structure of HR System:
|
Sales Staff |
|
|
|
|
|
|
|
|
Staff_id |
f_name |
l_name |
|
phone_no |
salary |
Staff_ofc_id |
Cus_id |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Staff office |
|
|
|
|
|
Staff_ofc_id |
Location_id |
Country_id |
Region_id |
Office_id |
|
|
|
|
|
|
|
|
|
|
|
|
|
Region |
|
|
Region_id |
Region_name |
|
|
|
|
Countries |
|
|
|
Country_id |
Country_name |
Region_id |
|
|
|
|
|
Location |
|
|
|
|
|
Location_id |
Street_address |
Postal_code |
City |
Country_id |
|
|
|
|
|
|
|
Customer |
|
|
|
|
|
Cus_id |
Customer 1 |
Customer 2 |
Customer 3 |
Staff_id |
|
|
|
|
|
|
|
|
|
|
|
|
Task B
Figure 3: Context diagram
(Source: Created by Author using MS Visio)
Figure 4: LEVEL DATA FLOW DIAGRAM
(Source: Created by Author using MS Visio)
Figure 5: LEVEL 1 DATA FLOW DIAGRAM
(Source: Created by Author using MS Visio)
CRUD MATRIX
|
Processes |
Course |
Section |
Enrolment |
Transcript |
Student |
Waitlist |
|
Verify Prerequisite |
|
|
|
|
|
|
|
Room availability |
|
|
|
|
|
|
|
Enrol |
|
|
|
|
|
|
|
Notification |
|
|
|
|
|
|
|
Registration Request |
|
|
|
|
|
|
|
Add waitlist |
|
|
|
|
|
|
Table 2: CRUD Matrix
(Source: Created by Author)
References
Btoush, E.S. and Hammad, M.M., 2015. Generating ER diagrams from requirement specifications based on natural language processing. International Journal of Database Theory and Application, 8(2), pp.61-70.
Greenyer, J., Brenner, C. and La Manna, V.P., 2013. The ScenarioTools play-out of modal sequence diagram specifications with environment assumptions. Electronic Communications of the EASST, 58.
Xu, Y., Mou, L., Li, G., Chen, Y., Peng, H. and Jin, Z., 2015. Classifying relations via long short term memory networks along shortest dependency paths. In Proceedings of the 2015 Conference on Empirical Methods in Natural Language Processing (pp. 1785-1794).
Buy Ict40115 Certificate Iv In Information Assessment Answers Online
Talk to our expert to get the help with Ict40115 Certificate Iv In Information Assessment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
