Q3: National Textile University is a Federal charred university that offers both undergraduate and graduate-level degree programs under different schools. Accordingly, the staff in NTU is categorized into academic and non-academic staff. The segregation of academic staff is as per their job designation and department in each school. The hiring of the academic staff is based on their qualification, experience, expertise, and job terms in the relevant departments situated in different locations. Similarly, the admission of the students to a degree program is based on their preferences or interest. In each program, the segregation of the courses in different semesters is based on the curriculum approved by HEC and University. The students must enroll in these courses in each semester to fulfill the degree requirements (e.g., grading. SGPA, CGPA). Please determine the business rules to describe the data required for the admission, assessment, and staff hiring process. Also, identify the entities, attributes for a relational database using the business rules. Draw the conceptual model (ERD) for the proposed using MS Visio. Finally, create a data dictionary for the proposed database.
Q3:
National Textile University is a Federal charred university that offers both undergraduate and graduate-level degree programs under different schools. Accordingly, the staff in NTU is categorized into academic and non-academic staff. The segregation of academic staff is as per their job designation and department in each school. The hiring of the academic staff is based on their qualification, experience, expertise, and job terms in the relevant departments situated in different locations. Similarly, the admission of the students to a degree program is based on their preferences or interest. In each program, the segregation of the courses in different semesters is based on the curriculum approved by HEC and University. The students must enroll in these courses in each semester to fulfill the degree requirements (e.g., grading. SGPA, CGPA).
Please determine the business rules to describe the data required for the admission, assessment, and staff hiring process. Also, identify the entities, attributes for a relational
Step by step
Solved in 3 steps with 1 images
