Based on the following scenario: Salim Bersaudara Sdn Bhd (SBSB) is a factory that produces electronic components and has 300 employees. Products will be shipped to customers throughout Malaysia. SBSB also had to provide an extensive database system to manage the information of its employees and customers. This database is managed by three IT staff and can be accessed by human resources and accounts department staff. (c) Explain THREE (3) reasons why SBSB needs to implement access control in accessing its database.

Based on the following scenario: Salim Bersaudara Sdn Bhd (SBSB) is a factory that produces electronic components and has 300 employees. Products will be shipped to customers throughout Malaysia. SBSB also had to provide an extensive database system to manage the information of its employees and customers. This database is managed by three IT staff and can be accessed by human resources and accounts department staff. (c) Explain THREE (3) reasons why SBSB needs to implement access control in accessing its database.

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 2.1CTQ

See similar textbooks

Similar questions

Discuss practical scenarios where you might choose not to fully normalize a database schema. What are the trade-offs involved in such decisions?
Discuss the concept of database normalization and denormalization. When might you denormalize a database, and what are the potential trade-offs?
Explain the terms "information repetition" and "information incapacity to portray." Explain why each of these characteristics might point to a faulty relational database architecture.
Using Crow’s foot notation, draw an ER diagram of the conceptual schema for another part of a University database, described as follows: You must show connectivity, cardinality, participation and relationships strength. Academic staff, general staff and students are the only persons at the university. Each person is either an academic staff, or a general staff, or a student. A person is uniquely identified by a PerId (person's ID), and has a Name and an Address. An Address is composed of HouseNo, Street, and City. A characteristic property of a student is that she/he has at least one Major and one NoOfPts (number of points) for each major. An academic staff has a Position and an AcQual (academic qualification). A general staff has a GenPos (general position). An academic staff teaches at most one course, whereas a student takes at least one course. A course is uniquely identified by a CourId (course ID), and has a CourName (course name). Each course is taught by at least one academic…
Explain how Excel can be used to design a database, including an example of a basic database layout that would be appropriate for, say, a gradebook for a graduating class’s overall GPA. Then, imagine that a business existed that used students’ information to propose specific colleges for them. What columns from the original spreadsheet would be kept? Propose at least four columns that would be added to a database for such a business, explaining how they would collectively help the business’s database function.
Suppose that we have to create a database for a car dealership. Identify 2 entities How the entities you identified are related? write the business rule create the crow's foot diagram as well as the Chen model diagram.
Describe the database management strategy to managing a company's data resources in detail, highlighting its six benefits and four constraints.
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate for one case study.DB for Railway ReservationPurpose: The Database is for a railway reservation system which facilitates the passengers to enquire about the trains available on the basis of source and destination, booking and cancellation of tickets, enquire about the status of the booked ticket, etc. The database is for maintaining the records of different trains, train status, and passengers. The record of train includes its number, name, source, destination, and days on which it is available, whereas record of train status includes dates for which tickets can be booked, total number of seats available, and number of seats already booked.Passengers can book their tickets for the train in which seats are available. For this, passenger has to provide the desired train number and the date for which ticket is to be booked. Before booking a ticket for a passenger, the validity…