ก Demonstrate the database concepts for the following scenario: A company management wants to compute the net salary of each group of employee based on the category of the employee such as Category A, Category B, Category C. Compute the net salary based on the following table. Category Tax Deducted Dearness Allowance(DA) A 30% of gross 80% of basic salary salary B 20% of gross 50% of basic salary salary C 10% of gross 30% of basic salary salary L

ก Demonstrate the database concepts for the following scenario: A company management wants to compute the net salary of each group of employee based on the category of the employee such as Category A, Category B, Category C. Compute the net salary based on the following table. Category Tax Deducted Dearness Allowance(DA) A 30% of gross 80% of basic salary salary B 20% of gross 50% of basic salary salary C 10% of gross 30% of basic salary salary L

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider the following Books database which is used to keep track of books and their readers. Assume that the database is composed of the following three relations where the key attributes are underlined. BOOK Title PERSON READS PID 111 111 222 333 444 BID PID 111 Gender BookID StartDate 2/4/2015 PYear Price Name 2 Internet programming Database System Programmin g using C++ 1 2016 50 Sami M 3 2/6/2015 8/4/2017 Khawla Rawan Zainab Khamis 222 2 2013 45 4 333 444 2 2/6/2015 3 2011 25 555 M 2 2/4/1995 444 1 2/8/1995 Operating Systems Oracle DBMS 4 2009 35 5 2017 50 • Write a SQL query to display the information including title, name (person name), and PID of all the books which have been read (StartDate) in the year 2015, and the price of these books is less than 50. Convert the generated SQL query into a Relational algebra query. Then, draw the optimized query tree (fifth step of query optimization). Note: You can draw a tree on a paper, scan, and upload in the Moodle OR you can describe…
QUESTION 14 Consider the database schema below for cities in countries. A country have many cities, and the same city name can be found in different countries. Country (ID: integer, Name: String (unique), SN: serialNumber (int)(unique)) City (serialNo: integer (unique, not null), CountryID: Integer, CityName: String, Population: integer) The same country (ID , name) can be added twice in Country relation with different SN? No, violates entity Integrity constraint No, violates referential integrity constraint. No, violates key constraint. Yes. No, violates domain constraints.
A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…
Database Principle and Application - 10 ========================== There is a Company Database that manages the data of employee, department and project. The relational schemas are as follows: EMPLOYEE (Fname, Lname, Employee_id, Gender, Salary, DNO). The attribute means: First name, Last name, employee id, gender, salary, the department number in which the employee works. Each employee has a unique employee id, and can join in projects that in different department. DEPARTMENT (DNO, Dname, Manager_id, Dlocation). The attribute means: Department number, department name, department manager id, department location. The department manager is a type of the employee, thus the Manager_id is a foreign key that references the Employee_id in EMPLOYEE table. PROJECT (Project_NO, Pname, DNO). The attribute means: project number, project name, department number of the department that the project belongs to. Part of the data in the relations are as follows： Table1 EMPLOYEE Fname Lname…
JoziCleaners is local cleaning service that is looking to upgrade their current operations by making use of a database to keep track of the teams, houses, clients and billings of each client per/week. Each house is cleaned by one or more teams. A team goes out to a particular house on a certain day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day, except the team leader who earns a unique amount. The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a spreadsheet in Figure 1 below. Day Client Client Name Team Members Team Leader Leader Total Code ID Wage Monday Aeliana Gebahard T3 6. Jaymes Merrickson R 350 R 850 C10 Alfher Dareia T1 Geoffrey Glover R 250 R 750 C8 Felina Diodotus T2 Elmer Victorson R 300 R 700 Brutus Sigihild Sigibert Quirinus Brutus Sigihild C9 T4 Norris Mamadou R 400 R1 000 Tuesday CS T3 Jaymes Merrickson R 350 R 850 C9 T2 5 Elmer Victorson R 300 R 700 Alfher Dareia Duncan Gardyner Geoffrey Glover…
A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…
Relation algebra (Database)
Database Management Systems
Build a relational model for the following ER schema
Air West Airlines is a regional carrier that operates primarily in the southwestern United States. Draw an ER diagram to capture the following information in a database for the airline company. An airport is identified by a unique airport code and has a location which consists of (city, state), an elevation, and one or more phone numbers. An airport may have several flights to arrive at it and depart from it. A flight has a unique flight number, a base fare, and the number of seats. A flight can arrive at one or more airports and depart from one or more airports. For each arrival, the scheduled arrival time should be recorded. For each departure, the scheduled departure time should be recorded. Each flight has one or more staff members in its crew. Each staff member (who may be an attendant or a pilot, but not both) has a unique ID number, a name, and a hire date. A staff member may be assigned to several flights. Each flight attendant has a date for an advanced certification. Each…
Read the scenario carefully You have to propose and optimal database design in RDBMS for a super store. In which clients came and can purchase products according to their likes and dislikes. Super store have same products of different companies. In the end client received a receipt of their purchase from counter he/she go for bill. Database also save records of stock according to FIFO system.Your required to define1) Entities and their attributes2) Attributes Types 3) Each Attribute Required space.4) Define keys of each entity 5) Defile relationship between the entities.