Question 1: Create a structure to specify data of employees in CS Department. The data to be stored is: Employee ID, Name, designation, Date of Joining and a flag to know whether the current employee is still in service or not. Assume maximum of 20 employees in the CS Department. Your program must be menu driven with following options: 1. Add a record (Employee ID, Name, Designation and Date of Joining of each employee) 2. Print the Employee ID, Name, Designation, Date of Joining and Status (whether the employed still in service or left) of each employee in tabular format. 3. Search specific employee. 4. Calculate total service of each employee.

Question 1: Create a structure to specify data of employees in CS Department. The data to be stored is: Employee ID, Name, designation, Date of Joining and a flag to know whether the current employee is still in service or not. Assume maximum of 20 employees in the CS Department. Your program must be menu driven with following options: 1. Add a record (Employee ID, Name, Designation and Date of Joining of each employee) 2. Print the Employee ID, Name, Designation, Date of Joining and Status (whether the employed still in service or left) of each employee in tabular format. 3. Search specific employee. 4. Calculate total service of each employee.

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

Given the following Class table, write the DML statement to add a new class with the following information: The new class is "DBDA-001" with the class code 10095 The new class will be for Section 1 on Thursday 6:00-9:00 p.m The room for the new class is at "CIS 101". The professor's code (emp_code) to teach the new class is still undetermined.
INSERT INTO Athletics VALUES((100, 'Samuel', 'David', '1967-11-17', '23',1967-11-20); INSERT INTO Athletics VALUES((110, 'Mario', 'Cassius', '1967-11-13', '22',1967-11-20 ); INSERT INTO Athletics VALUES((104, 'Mario', Ace', '1967-12-31', '26',1967-11-20 ); INSERT INTO Athletics VALUES((123, 'Cristisno', 'Ronny', '1965-11-13', '28',1967-11-20 ); INSERT INTO Athletics VALUES((110, 'Harx', 'Wale', '1964-11-12', '20',1967-11-20 ); QUESTION Create a stored procedure named sp_InsertAthleteDetails, which enters details into the Athletics table by using 4 parameters for the first four columns in the Athletics table. Set No Count on.
Q1 ): You are about to design a university database to keep information about departments, professors, and course offerings. Here is what you have been told about this application. Departments are identified by a code (e.g. CSE) and have a name (e.g., "Computer Science and Engineering"). Professors are identified by their initials (like "MNK1"), they have a name, and they are affiliated with at least one department. Professors are either tenured ("tenured" means permanent) or junior (they have to be in one of these categories and they cannot be in both). For tenured professors we want to know the year they earned tenure (year when they became permanent) and for junior professors we want to know the date they were hired. Finally, a department has exactly one chairperson who must be a tenured professor in any department (i.e., there is no requirement that the chairperson is affiliated with the department s/he chairs). A department (e.g., CSE) lists courses to be offered to students for…
6. SELECT e.Last_Name, m.Last_Name AS "Manager Name", e.Salary*12 AS "Annual Salary", 1.City FROM employees e JOIN employees m ON e.Manager_id = m.Employee_Id JOIN departments d ON d.Department_id = e.Department_Id JOIN locations 1 ON 1.Location_id = d.Location_id WHERE 1.City = "California"
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
Study the relational schema: EMP(ID, Name, DeptID) DEPT(DeptID, DName, Loc) Which of the following join conditions will correctly join the two tables? a. Emp.Name = Dept.DName O b. Emp.ID = Dept.ID O c. Emp.DeptID = Dept.DeptID %3D d. Emp.ID = Dept.DeptID %3!
I have to create a database using python to show geographical points. Create a program the will create your database and insert at least five points. Use your own data, something like: 100, 200, 123, Main Campus 120, 133, 142, Montoya 153, 123, 322, Rio Rancho 133, 123, 143, STEMULUS Center 153, 142, 122, ATC Run your initialization code to create the database.
A multinational company hired you to develop their employee management system. There are many employees working in different positions and departments. Make a structure for each department telling the number of employees in that department including the heads. Also each position has a reporting head defined in the chart given below also state the reporting head in the employee structure. Make a structure for all the employees holding their bio – data which includes: Name Employee ID CNIC Phone Number Age Department Position Add more necessary variables as required. Create functions to perform these operations: Add Employee Modify Employee Delete Employee Print All Employee Display Details of all Employees Search Employee using Position Search Employee using Department Search Employee using Employee id
Complete questions 2-7 Note: Complete questions 2-7 in part B of the Garden Glory Project on p.129 and 130 of the textbook (8th edition). There may be more than one service performed at a property on a given date. Use this information when you answer questions. Comment on each question whether a given design is good and provide reasons for that. For example, the answer for Q1 is “This design is not appropriate because the designated Primary Key (PK) (PropertyName) in the table cannot determine some other attributes of the same table (e.g., ServiceDate, Description, Amount); in other words, the designated PK is not unique”. Your answers need to be specific and should clearly pinpoint the design problem with references to the relevant attributes in the table and the reason of violation. Any vague answer like “This design is bad because the PK is not good”, are wrong. Note that the foreign keys are italicized instead of dashed underlined. Clearly label answers for each question.…
c# Create a small Sports database with two tables: Team and Athlete. The Team table should include fields for the type of team (e.g., basketball), coach's name (both last and first), and the season the sport is most active (S for spring, F for Fall, or B for both). The Athlete table should include fields for student number, student first and last names, and type of sport. Use the same identifier for type of sport in both tables to enable the tables to be related and linked. Populate the tables with sporting teams from your school. Write a C# program that displays information about each team, including the names of the athletes. The data base we have provided to us just need to know how to program it in with the other guidelines given.
For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.
(1) Prompt the user for a title for data. Output the title. Ex: Enter a title for the data: Number of Novels Authored You entered: Number of Novels Authored (2) Prompt the user for the headers of two columns of a table. Output the column headers. Ex: Enter the column 1 header: Author name You entered: Author name Enter the column 2 header: Number of novels You entered: Number of novels (3) Prompt the user for data points. Data points must be in this format: string, int. Store the information before the comma into a string variable and the information after the comma into an integer. The user will enter -1 when they have finished entering data points. Output the data points. Store the string components of the data points in an ArrayList of strings. Store the integer components of the data points in a second ArrayList of integers. Ex: Enter a data point (-1 to stop input): Jane Austen, 6 Data string: Jane Austen Data integer: 6 (4) Perform error checking for the data point entries. If…