The following is a list of entries with level numbers in a file of employee records:1 Employee(200) 2 SSN(Social Security Number) 2 Name3 Last 3 First 3 Middle Intial 2 Address 3 Street3 Area 4 City 4 State 4 ZIP 2 Age 2 Salary 2 Dependentsa) Draw the corresponding hierarchical structure.b) Which of the items are elementary items?c) Considering the above phenomenon of if we want to keep the information ofEmployee (200) name and their performance grade categorized as (A, B, C, F)using pointer arrays.What do you think which representation approach of pointer array will be moreappropriate if we want to categorize employees according to performance gradequickly. Draw and justify you representation.

Answered: Image /qna-images/answer/5d626953-0ceb-4f53-818e-d2e86e5314db.jpg

The following is a list of entries with level numbers in a file of employee records: 1 Employee(200) 2 SSN(Social Security Number) 2 Name 3 Last 3 First 3 Middle Intial 2 Address 3 Street 3 Area 4 City 4 State 4 ZIP 2 Age 2 Salary 2 Dependents

The following is a list of entries with level numbers in a file of employee records: 1 Employee(200) 2 SSN(Social Security Number) 2 Name 3 Last 3 First 3 Middle Intial 2 Address 3 Street 3 Area 4 City 4 State 4 ZIP 2 Age 2 Salary 2 Dependents

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

Related questions

Q: Explain the importance of encryption in securing data during transmission over the internet.

A: Encryption plays a role in securing data during its transmission over the internet.It involves…

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

Q: Database course: Write SQL queries to do the following A. List names of IT students.…

A: The SQL queries are given in step 2.

Q: Question : Map the following ERD to relational schema (show primary and Foreign keys) CPR Supervise…

Q: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

Q: FIRST NAME LAST_NAME SALARY John Russell 14000 .4 Karen Partners 13500 .3 Alberto Errazuriz 12000 .3…

A: NOTE: Here student mentioned list employee managed by each manager. so here I am using manager id to…

Q: Identify 7 mistakes by giving a number (e.g., 1, 2). Clearly explain each mistake and what should be…

A: The ER model characterizes the applied perspective on an information base. It works around…

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: Given that there are two tables Employee and Orders. The attributes of each table are:…

Q: Question 8. All rows correspond to students whose rollnum's are between 20 and 30. (i) SELECT * FROM…

A: Given sentence in SQL database

Q: Write a SQL statement that will display the product ID, product name, and category only products…

A: In Step 2, an SQL statement is given that will display the product id, product name, and category…

Q: According to tables below, write 3 SELECT statements to exemplify LEFT, RIGHT and FULL OUTER JOIN…

A: JOINS JOINS in SQL are used to combine rows from two or more tables, based on a related column like…

Q: 1. The data type for Borrower_name in Borrowers Table is: A. Short text C. Currency B. Long text D.…

A: As the schema design tabular structure of the Borrowers table in question indicates that it is…

Q: According to tables below, write SELECT statements to exemplify nested and/or correlated nested…

A: Here are the sample SQL Query for the given options: 1. Display number of flights between 6.00 AM…

Q: Employee and Restaurant are two tables in a relational database: Employee (StaffNum, Name, WorksIn)…

A: The SQL queries for creating the tables and inserting data is given below First Create Restaurant…

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-

Q: I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: To write the SQL query.

Q: Machine Problem #2. Write a method-oriented Java program that asks the user to input two numbers and…

A: Step-1: StartStep-2: Declare variable num1, num2 and take input form the userStep-3: Declare…

Q: 1. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…

Q: Ph_No Bank Code Name Addr Branches N Bank Branch Bank Name Addr Branch No

A: When you make 1 to N relationship ,then automatically the class which has 1 written on it ,pass the…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Description The Employee table holds all employees including their managers. Every employee has an…

A: SQL query : -

Q: Customer ID Name Address Phone Card Password Usernam number number Employee

A: ERD diagram is given below

Q: Find the name and the age of the youngest graduate student (use subquery).

A: Subquery is a query written inside another query and here we use this concept to find the minimum…

Q: question 11 please use the picture below to answer the following question Write a SQL statement to…

A: Query: The below query is used to modify the InvoiceDate to today’s data for the customer ID 10.…

Q: Vacation days are based on status. Using the information in the lower table below, do a lookup in…

A: A lookup function is used to match a lookup value in a one-column or one-row range, and returns the…

Q: Write the standard MYSQL query to retrieve the average customer balance grouped by SalesRepNo Write…

A: I have provided answers in step 2.

Q: ormalise the table to 3rd Normal Form

A: Given : In the given question , we have provided the table. The task is to perform the 3NF on the…

Q: SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the…

A: SQL: SQL stands for Structured Query Language. It is easy to learn. It is a standard language for…

Q: Bookstore Members MemberID First Name Last Name Address Phone Number Email Date of Birth Sales…

A: A Database Management System (DBMS) provides an interface for users to interact with the database…

Q: Question 20 The query in the figure below: Field: LastName Table: MEMBERS Sort: Show: Criteria: Like…

A: Defined the query in the given figure

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Q: Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID…

A: The given question are true are false question. So can I explained in detailed below.

Q: write SQL statement to search for employees whose manager is specified by the txtEname box

A: Note: Taking "JONES" as a sample name that will be specified in the txtEname box. The above-given…

Q: Input table into sql workbench

A: The steps to create a new table is as follows : Open the SQL Workbench and connect to the MYSQL…

Q: Adjust the following information so that 1) all users on the system are able to run the SQL…

A: SUMMARY: -Hence, we set the code.

Question

The following is a list of entries with level numbers in a file of employee records:
1 Employee(200) 2 SSN(Social Security Number) 2 Name
3 Last 3 First 3 Middle Intial 2 Address 3 Street
3 Area 4 City 4 State 4 ZIP 2 Age 2 Salary 2 Dependents
a) Draw the corresponding hierarchical structure.
b) Which of the items are elementary items?
c) Considering the above phenomenon of if we want to keep the information of
Employee (200) name and their performance grade categorized as (A, B, C, F)
using pointer arrays.
What do you think which representation approach of pointer array will be more
appropriate if we want to categorize employees according to performance grade
quickly. Draw and justify you representation.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

a) Hierarchical structure

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

I need C please
e) Display the sum of salaries of employees from each department ordered in ascending order.
What is the use of sub queries?
SQL query question
1. Make a table of five columns “Name", “Midterm Score", “Final Term Score" , “Average" and Grade. Below 60 = F Above 60 =D Above 70 = C Above 80 = B Above 90 = A
In SQL This sample database consists of the following tables(see image for tables and there is one more at the bottom in this text):• Customers: stores customer’s data• Products: stores a list of scale model cars• ProductLines: stores a list of product line categories• Orders: stores sales orders placed by customers• OrderDetails: stores sales order line items for each sales order• Payments: stores payments made by customers based on their accounts• Employees: stores all employee information as well as the organization structuresuch as who reports to whom• Offices: stores sales office data Write SQL code for the following:We want to add a new sale order for the customer (customerNumber = 145) in thedatabase. The steps of adding a sale order are described as follows:(1) Get latest sale order number from “orders” table, and use the next sale ordernumber as the new sale order number(2) Insert a new sale order into “orders” table for the customer (customerNumber =145). For this order, the…
List the name of each department, and its total number of employees, and the total amount of salaries
Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following rows ID DEPT SALARY NAME 100 SALES 40000 Smith 101 RD 38000 Terry 102 HR 60000 David 103 SALES 58000 Ellie 104 RD 70000 Judy The DEPARTMENT table contains two attributes, DEPTNAME and PHONE, and has the following rows: DEPTNAME PHONE RD 8596001234 SALES 8596005555 HR 8596009876 A.) The EMPLOYEE table needs to enforce the following integrity constraints: • The ID is the primary key. • The DEPT column is a foreign key that references the DEPTNAME in the DEPARTMENT table, so that any value that appears in the DEPT column should also exist in the DEPARTMENT table. • The value for the NAME column can never be null. What should be the statement used to create the EMPLOYEE table, if 1) the table was created as a partitioned table such…
Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date.