Computers and Technology
A local university keeps records of their students to track their progress at the institution. The name, student number, sponsorship number, physical address and phone, postal address, date of birth, gender, study mode (full time, part time, distance), faculty (Computing and Informatics, Engineering and Built Environment, Commerce and Human Sciences) and degree programme (Bachelor, Honours, masters, PhD) are recorded. The system used in the finance department requires the students physical address to clearly specify the erf number, location, street and city name. The students are uniquely identified by their student number and the sponsorship number. Each faculty is described by a name, faculty code, office phone, office location and phone. The faculty name and code have unique values for each faculty. Each course has a course name, description, course code, number of hours per semester, and level at which it is offered. Courses have unique course codes. A grade report has a student name, programme, letter grade and a grade (1,2,3,4). A faculty offers many courses to many students who are registered for a specific programme
Maintain a Database Security (Inference Detection Algorithm)Consider a database containing personnel information, including names, addresses, and salaries of employees. Individually, the name, address, and salary information is available to a subordinate role, such as Clerk, but the association of names and salaries is restricted to a superior role, such as Administrator. 1. With this information, how could you construct your database and tables? Design your database and draw a database schema first. 2. Suppose that administrators wants to add a new attribute, employee start date, which is not sensitive. Where would it be? Consider not comprimising the relationship between employee and salary. Draw your new schema