TNB Berhad is creating a new human resource system that will record its new staffs' salary payment and termination processes. In this system (TNB HR Recording), the new staffs will enter their application for a new account. A new member account will be created and the details will be saved in the employee file and member account file. By the end of each month, the system will generate the employees' bank statements, data compiled from employee and member account files. The bank statement is given to each employee. For any employee been terminated or contract completed, the details are gathered from the employee file and processed. The CEO will be informed of the termination contract details. He will then approve all the termination contracts and the system will update in the job termination file and freeze account number of those terminated staffs. The frozen accounts are compiled into a report (Frozen Account notification) and the Account Receivable Department will be notified. Prepare a data flow diagram level-0. Show the entities, processes, data flows and data stores involved

TNB Berhad is creating a new human resource system that will record its new staffs' salary payment and termination processes. In this system (TNB HR Recording), the new staffs will enter their application for a new account. A new member account will be created and the details will be saved in the employee file and member account file. By the end of each month, the system will generate the employees' bank statements, data compiled from employee and member account files. The bank statement is given to each employee. For any employee been terminated or contract completed, the details are gathered from the employee file and processed. The CEO will be informed of the termination contract details. He will then approve all the termination contracts and the system will update in the job termination file and freeze account number of those terminated staffs. The frozen accounts are compiled into a report (Frozen Account notification) and the Account Receivable Department will be notified. Prepare a data flow diagram level-0. Show the entities, processes, data flows and data stores involved

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....

See similar textbooks

Similar questions

Cinmaplex is a large library that borrows books to all members in the society. This library needs to maintain a record of its members and borrowed books in a database. The details about members need to be stored including member identification number, member name, telephone number and address. The details of available books are stored in the database. The database should contain a unique identification number for each book, book title, book rating and number of copies. As books are rented, transactions are recorded. Every transaction records an invoice number is automatically generated, schedule, date of return, actual date of return and final amount if required. Use Ms Access to create the entities and attributes identified in the case study. Hint: Make sure all tables are normalized.
A financial company hired a team to develop a new system that will help them improve their business. After a requirements elicitation phase, the following requirements were prioritized.1) The system should allow customers to self-register for an account with the financial institution.2) The system should allow the management of investments by customers.3) The system should be able to guarantee data integrity even in the case of errors during a transaction.4) The system should support 1,000,000 transactions per month.5) The system should be implemented using open-source software.6) The system should allow customers to pay debts from their mobile applications.7) The system should comply with the Open Banking Standard.8) The system should be accessible for people with disabilities (visual, hearing, physical, cognitive, and neurological).9) The system should generate weekly reports about investments.10) The system should allow customers to make part of their savings available to be lent…
Logical level of data abstraction deals with how a record is stored. True or False?
BizMic Multiples BizMic Multiples is an IT company that manages the Gauteng Province database system. In the past, they built a system that stores and accesses records of all the SA citizens in Gauteng Province in a direct access table. A direct access table involves the creation of a big array and uses phone numbers as an index in the array. As time goes on and the population continues to grow, it has now become very difficult to access a record from the traditional method. The system has now become very slow due to a large amount of records stored in it. The BizMic Multiples IT Company has consulted with an auditing firm who recommended a system that uses an array that stores pointers to records corresponding to a given record. This system, known as Hash Data Structures or simply Hash Table, is intended to improve on the existing system. As the lead IT intern at BizMic Multiples, your unit (you and your team members) is saddled with the responsibility of overseeing the success of the…
Please help me interpret this.
It is recommended that the following be covered in every training session for a new user of the school database:
Scripts and stored procedures are two different kinds of items that may be used in databases. How do their differences from one another manifest themselves? They each engage in a variety of activities. If you want to implement stored procedures, it is strongly recommended that you do it via the usage of a database rather than through any other method.
An employment agency offers the service of finding the employee candidates for their clients. For this purpose, the agency has to keep track of certain particulars of the candidates such as the name, identification card numbers, address, phone numbers, data of birth, and their field of expertise. They also keep the data of their clients which is the future employer for the candidate's employee. The request for employee is forwarded to the agency by future employer along with the information regarding to the job offered. The information includes the type of jobs, offered salary, type of expertise required and the date when the employee is needed. Therefore, as a database designer, you are required to propose a database design prior to its implementation by presenting the following: (a) Identify ALL possible entities that could exist in the organization process (give suitable entity name), complete all the entities with suitable attributes together with assigned primary key. Use your own…
A university wants to set up a database to record details about its staff, the departments they belong to and the training they attended. The purpose of developing the database is keep the staff information such as staff identity number, staff name, staff address, staff telephone number, staff job title and staff salary. As for the staff telephone number, the database allows keeping more than one of the staff telephone numbers. For the department information, the database keeps the name of the department and its location. It is required that every staff belongs to at least one department. Also, it is required that each department has exactly one staff to lead the department. To improve staff self-development, the university encourages every staff to attend courses. Hence, the database keeps the course information such as the course name, course duration, and course cost. Each staff is required to attend at least one course. For one course, the university can approve a number of staff…
A Cougars Real Estate Inc. (CRE) sells houses. People who want to sell their houses sign a contract with CRE and provide information on their house such as the current owner’s SSN, the owner’s name, the address of the house, the number of rooms, the number of baths, and the square feet of the house to a staff of CRE who is responsible for the management of house information. Then, the information is entered into the database by the staff of CRE. This information is kept in a database and a subset of this information is sent to the citywide multiple listing service used by all real estate agents. CRE works with two types of potential buyers. Some buyers have an interest in one specific house. In this case, advising specialists of CRE (advising specialists don’t manage the house information) print information from its database, which the advising specialists use to help show the house to the buyer. Other buyers seek CRE’s advice in finding a house that is wider than 2000 sq ft. In this…
A Cougars Real Estate Inc. (CRE) sells houses. People who want to sell their houses sign a contract with CRE and provide information on their house such as the current owner’s SSN, the owner’s name, the address of the house, the number of rooms, the number of baths, and the square feet of the house to a staff of CRE who is responsible for the management of house information. Then, the information is entered into the database by the staff of CRE. This information is kept in a database and a subset of this information is sent to the citywide multiple listing service used by all real estate agents. CRE works with two types of potential buyers. Some buyers have an interest in one specific house. In this case, advising specialists of CRE (advising specialists don’t manage the house information) print information from its database, which the advising specialists use to help show the house to the buyer. Other buyers seek CRE’s advice in finding a house that is wider than 2000 sq ft. In this…
Study Case Statement: Semuarasa Restaurant is a restaurant that is famous for its taste, so it has many customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, although it already has many branches and the number of order transactions is very large every day, this Semuarasa Restaurant does not yet have an application and database to manage transactions and data. Recording orders and sales reports are still done manually. Restaurant owners know that information technology can support their business so they plan to build applications to serve food orders both offline and online. Question: a) In the database design stage, it is known as a bottom-up, top-down and inside-out approach. Explain the three approaches! b) In your opinion, what approach is used for database system development at Semuarasa Restaurant? Explain why you chose this approach!