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.

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter12: Event-driven Gui Programming, Multithreading, And Animation

Section: Chapter Questions

Problem 15RQ

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

brainwash briefcivilize coach cultivatedevelop discipline drilledify enlighten exercise explainfosterimprove indoctrinate inform instructmaturenurturerearschooltrain tutor objective blessed blest blissfulcheerful contenteddelightedecstatic elatedgladjoyful joyous jubilantlivelymerryoverjoyedpeaceful pleasant pleasedthrilledupbeat import java.util.Scanner;import java.io.FileInputStream;import java.io.IOException; public class LabProgram { public static void main(String[] args) throws IOException { Scanner scnr = new Scanner(System.in); int NUM_CHARACTERS = 26; // Maximum number of letters int MAX_WORDS = 10; // Maximum number of synonyms per starting letter String[][] synonyms = new String[NUM_CHARACTERS][MAX_WORDS]; // Declare 2D array for all synonyms String[] words = new String[MAX_WORDS]; // The words of each input line /* Type your code here. */ }}
Listen Bowler Scores MatchiD Gameiumber BowleriD Bowlers BowlerD BowlerlLastName RawScore Match Games BowlerFirstName HandiCapScore MatchiD GameNumber BowlerMiddleinit Teams WonGame BowlerAddress 00 TeamiD WinningTeamiD BowlerCity BowlerState TeamName CaptainiD BowlerZip Tourney Matches BowlerPhoneNumber MatchiD TeamiD 00 TourneylD Tournaments Lanes Teams 1 TourneylD OddlaneTeamID TourneyDate TeamiD EvenlaneTeamiD TourneyLocation TeamName CaptainiD Write an SQL Query that lists the TeamlD, bowler name, and telephone number for all bowlers. The name should be a single value formatted appropriately and returned with an appropriate column heading. For example, return 'John Doe' as the Name column. Sort your results so that all the bowlers on the same team are together and then by last name and then by first name.
Harry Pottertheboywholived@hogwarts.eduHermione Grangerbrightestwitch@hogwarts.eduRon Weasleyroonilwazlib@hogwarts.eduDraco Malfoymyfatherwillhearaboutthis@hogwarts.eduSeverus Snapehalfbloodprince@hogwarts.eduAlbus Dumbledorealasearwax@hogwarts.edu Your program should read from the file, storing the names and corresponding email addresses in a dictionary as key-value pairs. Then, the program should display a menu that lets the user enter the numbers 1 through 5, each corresponding to a different menu item: 1) look up an email address2) add a new name and email address3) change an email address4) delete a name and email address5) save address book and exit When the user enters 1, the program should prompt them for a name, and then print the corresponding email address. If there is no dictionary entry under that name, the program should print, "Sorry, no contact exists under that name."When the user enters 2, the program should prompt them for a name and an email address, then add a new…
sdasdsadasdasdasdadasdsadasdasd
....Jdjssjsiwoworifosoawjejfucjeiwoaakskdkdkeieoqoqoxoxjdekwoakxmfiei...
gjgjydytttttttfd
rfgbgfrerfgbngrrg
E3 In this project, you are asked to independently research and write a short report relating to our discussion on Biofuel Energy. Your topic selection is completely of your choosing, though the report must clearly demonstrate how the subject is relevant to the overall topic of Biofuels. This course presents introductory discussions through module content and our weekly lectures, to enhance this learning it is up to the student to further explore and independently research topics of interest. The goal of this research report is to explore what interests you, and get on paper your ideas about this area of renewables technology. The marking scheme rewards originality and uniqueness of topic selection. Students with same/similar topics will loose significant marks. Plagiarism will result in a 0 mark, and will be dealt with according to Conestoga Academic Integrity policies. As this is a research report, it is important to develop an overview or a thesis statement about the topic you wish…
Rrffftt
0py.in.
Que 4 Computer Science Using your class materials describe one thing a user can do, and on thing they cannot do while waiting for a long running foreground process to complete.
VShow all working explaining detailly each step