Use the following ERD to answer the next 2 questions:What is the primary key of the WorkHours table?Indicate the redundant field in the Employees table. StartDateEndDateAssignedTo-ProjectsContractsProjectIDProjectNameHourCapAmountD0---- IncludesContractIDContractDescEmployees--ManagesEmpIDFirstNameHas- SupervisesRecordsLastNameOfficelDEmailSalaryContractTypesTitleWorkHoursContractTypelDContractTypeNaiLevellDSupervisorIDLogs--04 DayMonthYearHoursWorkedTimeSheetsTimeSheetlDSupApproveDate

This question comes from Database Management System which is a paper of Computer Science. Let's…

Answered: What is the primary key of the…

Engineering

Computer Science

What is the primary key of the WorkHours table? Indicate the redundant field in the Employees table.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter2: Hardware And Software

Section: Chapter Questions

Problem 15SAT

See similar textbooks

Related questions

Q: Use the Committee table and create a query that displays the following output: Name FullAddress…

A: The query is given as per mysql in the next step:

Q: the normalization process to normalize the above tables (you need not show the steps, but can use…

A: Given that 1. Follow the normalization process to normalize the above tables (you need not show the…

Q: Q. Consider the following relations: EMP_NO EMP_NAME EMP_GRADE JOB_ID DEPTNO START_DATE EMP…

A: Since multiple questions are asked,solving 1,2,3 repost remaining. 1. SELECT EMP_NAME||', '||JOB_ID…

Q: A. Work on the "Products" table from CO schema and apply the queries mentioned below. 1. Display the…

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: write the sql queries for the following er diagram: Create all the tables and relationships…

A: 1.create table Time CREATE TABLE Time(Time_ID int NOT NULL,Day int,Month int,Quarter int,Year…

Q: rite the SQL statements to create all of the necessary tables to represent the above diagram,…

A: Note: Since you have not provided the database name to write the SQL query so I am using the MYSQL…

Q: illustrate using students and professor tables what outer join is

A: Let’s consider two tables Students and Professor. Table: Students

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: Since you have not provided the database name to write the SQL query so I am using MySQL database to…

Q: Given the following tables (Primary Key, Foreign Key): CUSTOMER (CustomerNumber, Name, Address)…

A: Example- Considering the given tables, a view can be created for the details of sales done on a…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: 5. calculate the percentage of any student and round to 0 digit SELECT cast(round((457/500) *100),0)…

Q: Based on the following ER Model, write SQL statements to create the tables. USING SQL NOT MYSQL…

A: A relational database contains tables also known as relations. A relation contains tuples and…

Q: Questi on 1: Consi der the fol l owi ng schema: Suppl i er s( si d: i nteger, sname: stri ng, addr…

A: Following schema is given : Suppliers(sid: integer, sname: string, address: string)…

Q: Problems 1 and 2 are based on the following query: SELECT EMP_LNAME, EMP_FNAME,…

A: Database Management: Each and every organization contains a huge amount that needs to be stored for…

Q: Convert the following table to an equivalent collection of tables that are in third normal form.…

A: Ans:) Given Table: Patient (HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance,…

Q: Write SQL Queries for following set of tables: EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary,…

A: As per our guidelines, only 3 subparts will be answered. So, please repost the remaining questions…

Q: Refer to the below listed database diagram and develop SQL a query to find the names of all the…

A: What is SQL: SQL is a standard language for accessing and manipulating databases. SQL stands for…

Q: Using the INVOICE table structure shown in figure below answer the following question. Write the…

Q: Create tables for the following, where the first 2 are entity-types and the last one is…

A: Given Database tables have to be created where the first 2 are entity-types and the last one is…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: Given:

Q: Write a query to find the name of the student(s) who has scored maximum mark in Software…

A: Introduction: As per the given problem statement we are required to develop a SQL code to find the…

Q: Write a query to find the name of the student(s) who has scored maximum mark in Software…

A: As per the given problem statement we are required to develop a SQL code to find the name of the…

Q: Question 9 : Fill in the blanks in the following table with types of index. Index field is a key…

Q: What is the difference between a UNIQUE and a PRIMARY KEY constraint? (See the tables in the JustLee…

A: Introduction: When creating a table, a primary key is used to identify each row in the table, while…

Q: Study the relational schema: STUD(ID, Name, CID) COURSE(CID, PName, Price) Which of the following…

A: In step 2, you will get the answer. Join is used to mix rows from two or more tables based on the…

Q: 1. Display detail of all employees from Employee table. Answer: 2. Display name of employees, who…

A: The first three parts will be answered 1 To select all records from a table, SELECT along with *…

Q: You can join tables using the WHERE clause, the EXISTS operator, or the IN clause. Which one is the…

A: Database: A database is a collection of information, which is used to store and retrieve the…

Q: Consider the following schema and write the following queries in relational alge Product(pid, pname,…

A: 1. Use selection operator to select only those product where pname is shoes.…

Q: altering the framework of a table using SQL? In general, what different kinds of shifts are…

A: SQL "continuation"; Structured Query Language)[5] is a domain-explicit language utilized in…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: 1)Show all data from employee table where name should be in ascending and salary in descending…

Q: Can you write 10 query for this tables? Plase use join and nested queries Customer…

A: I give 10 queries

Q: What are the functions of each table? what is the forign key and Unique keys in each table?

A: The functions of each table and the forign key and Unique keys in each table are described in the…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

Q: Report the eid of every employee who manages at least two different people. Use the usual technique…

A: Below i have given sql query for the desired question:

Q: Consider the following tables: Employee (Emp_no primary key, Name, Emp_city, Company_name, Salary)…

A: table creation syntax:- create table tableName(columnName datatype(size) ); use like operator to…

Q: Three tables are given Student: studentNO, firstName, lastName, studentProgram Professor:…

A: 1. SELECT last name,studentProgram FROM Student UNION SELECT professor name, Professor Program FROM…

Q: Using the Schema - data/statistics Write down the following SQL queries. Assume appropriate data…

A: Create appropriate tables and do the given SQL queries Note: Dear user, as per company policy we…

Q: write the sql queries for the following

A: The queries in MySQL are as follows: To create the table named time and inserting 3 rows in it:…

Q: List the advantages of Table in Database? write short note about NULL value?

A: Question. List the advantages of Table in Database? write short note about NULL value? Answer. Some…

Q: Which of the following is not used to change a COLUMN in an TABLE? a. ADD b. MODIFY c.…

A: Which of the following is not used to change a COLUMN in an TABLE? Which of the following statements…

Q: Based on the following ER Model, write SQL statements to create the tables. Include all the…

A: Actually, SQL stands for structured query language.

Q: Write a query to find, name, hire_date, phone_number, department name for the employees in HR…

A: oehr_departments and oehr_employees are connected by department_id and manager_id in both the tables…

Q: Display the name concatenated with the job ID, separated by a comma and space, and name the column…

A: /*Create New table */ Create table Emp(EMP_NO int Primary key,EMP_NAME varchar(30),EMP_GRADE…

Q: Normalize the following table to satisfy BCNF: GRADE(StudentID, StudentName, SectionID, Term,…

A: Normalization Normalization is a database modeling approach that removes unwanted features such as…

Q: Consider the following tables: Employee (Emp_no primary key, Name, Emp_city, Company_name, Salary)…

A: The table is created by using CREATE TABLE command and followed by the table name. This will create…

Q: Can an outer join be easily implemented when joining more than two tables? Why or why not?

A: Outer join is not easily implemented in more than two tables.

Q: What is the importance of primary key in a table? Explain with suitable example.

A: Statement: The primary key of a relational table uniquely identifies each entry in the table in the…

Q: What is the definition of a calculated field? What is the best way to utilise one in a SQL query?…

A: Given that: What is a computed field? How can you use one in an SQL query? How do you assign a name…

Q: t utilizing the SQL programming language to change the format of an existing table? Which of these…

A: Summary First, you will start with a brief overview of the significance of learning SQL for data…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

100%

Use the following ERD to answer the next 2 questions:

What is the primary key of the WorkHours table?
Indicate the redundant field in the Employees table.

StartDate
EndDate
AssignedTo-
Projects
Contracts
ProjectID
ProjectName
HourCapAmount
D0---- Includes
ContractID
ContractDesc
Employees
--Manages
EmpID
FirstName
Has
- Supervises
Records
LastName
OfficelD
Email
Salary
ContractTypes
Title
WorkHours
ContractTypelD
ContractTypeNai
LevellD
SupervisorID
Logs-
-04 Day
Month
Year
HoursWorked
TimeSheets
TimeSheetlD
SupApproveDate

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Foundation

VIEW

Answer With Proper Explanation

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

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

Brieflydescribeinformationsystemactivitiesandgivepracticalexamplesaboutthe informationsystemactivitiesinyourorganizationoranyorganizationyouarefamiliar with.
this is an ssiegnment help with it plz and answer all the questions
Alert dont submit AI generated answer. Question 5 A program is a collection of related projects that share a common goal or purpose. O True O False
SolidityProf. Tim Berners-latest Lee's project Solid is exciting. Give us some background on Tim-Berners Lee and explain his new idea.
help ill be thankful fot lifetime
subject DLD plzz sopve urgent with complete detail thnx
Assignment #1:Dear Students, Please note the following before answer question below:1. Each student should answer all questions saved in word file and upload it on e-learning.2. The assignment must be submitted on time.3. Any Copy/Paste submitted will be graded ZERO.Suppose you have a program to send message to the second activity: The following button on the second activity is to go back to the first activity. The figures below clearly describe this process:Note:The first activity named: SendMessageActivityThe second activity named: BackActivityThe first button method named OnSend()The second button method named: OnBack() Write an android program that does the following:1. Send Message button to move from the 1st activity to the second activity.2. Back button to move back from the 2nd activity to the 1st activity
(Python) Dating App Scenario Interview Question Given a user Id Write/Design/Implement API functions to: 1. like someone's page 2. remove like from someone's page 3. find the most liked profile it should look like def add( int k): def remove (int k): def find(profiles): with implementation
Create a concrete plan that can be used to transfer past projects that were saved on DVDs to the students’ new laptops
The command pattern and strategy patterns are widely used patterns for encapsulating a behavior or an algorithm. What are the key factors that decide when each pattern can be used. Providing usage examples is encouraged.
val isPresent = intent.getBooleanExtra("present", false)val technology = intent.getStringExtra("technology")val plugged = intent.getIntExtra("plugged", -1)val scale = intent.getIntExtra("scale", -1)val health = intent.getIntExtra("health", 0)val status = intent.getIntExtra("status", 0)val rawLevel = intent.getIntExtra("level", -1)val voltage = intent.getIntExtra("voltage", 0)val fastchargestatus = intent.getBooleanExtra("fastcharge_status", false)val temperature = intent.getIntExtra("temperature", 0)var level = 0if (isPresent) {if (rawLevel >= 0 && scale > 0) {level = rawLevel * 100 / scale}voltageValue = voltage / 1000.0fbinding.PowerSource.text = getPlugTypeResultString(plugged)binding.BatteryVoltage.text = " $voltageValue V"binding.BatteryStatus.text = getStatusResultString(status)
I am creating simple window money changer via microsoft visual studio and am encountering errors(refer to the picture) I hope you can help me solve this one. this is my code using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms; namespace Act3_AggaraoMikael_608{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void label3_Click(object sender, EventArgs e) { } private void button1_Click(object sender, EventArgs e) { // Declares a variable double amount, converted = 0, exchange = 0; char currency; // Sstores the value of each textbox into variable amount = Convert.ToDouble(txtAmount.Text); currency = Convert.ToChar(txtCurrency.Text); // Uses Nested if…