You work for a large company called Ginger Bread working throughout the UK who provide baking equipment to large bakeries. Ginger Bread comprises of several traditional departments including; Research and development, Production, Finance, HR, Sales and Marketing and IT. Each department has roughly 85 members of staff. Each department implements a standard hierarchical management structure.
The company is undergoing database and IT system redevelopment. The new database and supporting software have already been design and created using the industry standard DBMS Oracle, version 10g. In large database systems there is a requirement for varying levels of access for different grades of users. Lower level users are restricted in what they can access.You have been asked by the IT director to establish a strategy to control user access to the system. You will need to design a hierarchy for access, bearing in mind the various operations used in database design, input, output etc. This should take the form of a managerial report considering the following privileges:
CLIENTS (CID, CompanyName, Address1, Address2, City, County, Postcode, Region, Phone, Fax, Email, WebSite, Notes)
STAFF (ID, CID, Firstname, Surname, Department, Gender, Grade, Trade, ContactNumber, LastPDR, Salary, Notes, Recommendations)
Consider appropriate use of the following example views:
sales_views(staff.firstname, staff.surname, departments.department_id, staff.contactnumber, notes, recommendations, clients.CompanyName, clients.allAddreessDetails,clients.allContactDetails)
admin_view(staff_id,did, firstname, surname, specialism, HomeContactNumber, notes)
postal_view(CID, company_name, address1, address2, city, county, postcode)
hr_view(contactid, cid, firstname, surname, department, grade, contact_number, salaries)
Note: there maybe errors or bad practice in the above tables.
- You need only implement 1 rep group (e.g. WALES)
- You need only implement 1 rep group (e.g. WALSE)
You will need to consider the use of synonyms
Ensure that all objects you create are suffixed with your login number e.g.
Appendix a - List of Priviledges represents a subset of the strategy for Ginger Bread. It reflects a possible approach to Ginger Bread security planning, suitable for implementation.
Appendix b - List of Users provides an outline of the number of users that will be assigned to each role. You will have to provide dummy data relating to users’ names
Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak: