Create a database 'XYZ_Company' with the following tables: Employees (name, id, position, team, department, team_leader) Administration (name, company_id, sector) Team Leader (name, id, department, team) Department_Head (name, id, department) Based on question 4, list the name, id, position of employees and their team leader's name where team is 'Microservices' and department is 'Engineering' Based on question 4, concat the Team Leader name and department Hea name by joining the two tables, name the column as "Department Info" and use the following format "Department head is and Team Leader is " where names are respectively of department Head name and team leader name

Create a database 'XYZ_Company' with the following tables: Employees (name, id, position, team, department, team_leader) Administration (name, company_id, sector) Team Leader (name, id, department, team) Department_Head (name, id, department) Based on question 4, list the name, id, position of employees and their team leader's name where team is 'Microservices' and department is 'Engineering' Based on question 4, concat the Team Leader name and department Hea name by joining the two tables, name the column as "Department Info" and use the following format "Department head is and Team Leader is " where names are respectively of department Head name and team leader name

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: A select operation in a relational database decreases the size of a table by deleting columns that…

Q: There are two basic ways to design a well-structured relational database. The method in which a…

A: A database system as the management system as the file of the processing as the based service of the…

Q: 8A-

A: The above given is a default schema of a database.

Q: Which of the following is false: A. Tables are joined by using primary key/foreign key combinations…

A: The following statement is false B. A primary key can consist of more than one attribute

Q: Required: Convert the E-R diagram you designed in last exercise into a relational database schema. •…

A: For question 1, You have not provided the ER diagram you designed in the last exercise, so we can't…

Q: consider the database below and answer the query. pk refers to primary key and FK refers to foreign…

A: Dear Student, The required script is given below -

Q: The database used for this question is a very simple one with the following schema: (Primary keys…

A: A) First, select rows whose item names are ”Black Scratcher” and “Hair Remover” give the I_Name to…

Q: consider the database below and answer the query. pk refers to primary key and FK refers to foreign…

A: Dear Student, The required query with explanation using inline comments is given below, the comments…

Q: What is the role of a "self-referencing" table in a relational database model?

A: A relational database model "self-referencing" table is one that has a foreign key column that…

Q: List the first and last names of Customers who come from the City named Perth. List the first and…

A: 1 Query: ∏FirstName, LastNameδCity = "Perth" (CUSTOMER) 2nd Query: ∏FirstName, LastName…

Q: Assume a university database's student table has indexes on StudentID (the main key) and Major, Age,…

A: Answer is

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Q: Using the types of entities database attached (trips, guides, customers, and reservations), create…

A: Trip_No Trip_Dt Trip_Dest Trip_Price Guide_Name Guide_Phone Cust_Name Cust_Phone…

Q: Create the following table in your database with the following schema: Table: Customer +- | Column…

A: syntax to create table:- create table tableName(column_name data_type constraint); syntax to insert…

Q: Complete the GROUP BY clause below to find the number of orders received per ye SELECT ... AS Year,…

Q: 2. Figure 11-34 contains sample data for pet sitters and customers who hire those sitters. In…

A: First Normal Form(1NF) A relation is said to be in 1NF, if there is an attribute or set of attribute…

Q: You will be using Relax again to help you build your RA expressions and answer questions based on a…

A: The objective of the question is to find the names of dealers who sell some black cars using…

Q: Create the ERD for this database.

A: The given assignment has three tables as below: 1) TRUCK 2) BASE 3) TYPE The requirement is to…

Question

100%

Create a database 'XYZ_Company' with the following tables:
Employees (name, id, position, team, department, team_leader)
Administration (name, company_id, sector)
Team Leader (name, id, department, team)
Department_Head (name, id, department)
Based on question 4, list the name, id, position of employees and their
team leader's name where team is 'Microservices' and department is
'Engineering'
Based on question 4, concat the Team Leader name and department Hea
name by joining the two tables, name the column as "Department Info"
and use the following format "Department head is <name> and Team
Leader is <name>" where names are respectively of department Head
name and team leader name

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

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

2. The following relational schema form a university database which is implemented in a relational database: student (s_ID, s_name, semester, year) department(d_ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the Relational Algebra for the following queries: a) Find your own name using your own registration number as the student ID. b) Show the ID and name of the department located at the floor number equals to the last digit of your own registration number. c) Find the codes and titles of the courses having credits more than 3 credits. d) Find the name of all students from your own semester and year.
Using the Crow’s Foot Diagrram technique, draw a database design for the attached database.
Colonial Adventure Tours is considering offering outdoor adventure classes to prepare people to participate in hiking, biking, and paddling adventures. Only one class is taught on any given day. Participants can enroll in one or more classes. Classes are taught by the guides that Colonial Adventure employs. Participants do not know who the instructor for a particular class will be until the day of the class. Colonial Adventure Tours needs your help with the database design for this new venture. In each step, represent your answer using the shorthand representation and a diagram. Use crow’s foot notation for the diagram. Follow the sample SQLite chinook database ERD (Download it from Blackboard Course Materials) a) For each participant, list his or her number, last name, first name, address, city, state, postal code, telephone number, and date of birth. b) For each adventure class, list the class number, class description, maximum number of people in the class, and class fee. c) For…
Hi, For this proble I need to create a table called instructor_course_nums within a university database schema. 1. I need to write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the instructor_course_nums table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. 2. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the instructor_course_nums table is up-to-date. Here is what I have that answers the first part of the question: CREATE TABLE instructor_course_nums ( id varchar (10), name varchar (30), tot_courses integer, CONSTRAINT instructor_course_nums_pkey PRIMARY KEY (id)); CREATE OR REPLACE PROCEDURE Student_00_insCourseNumsProc(ID varchar(10), name varchar (25), tot_courses…
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…
10A-
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. Each question is worth 2 marks. NOTE: You can use the symbolss, P, etc., or the words’ PROJECT’, ‘RESTRICT’etc.as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the first and last names of Customers who come from the City named Perth. List the first and last names of customers who had…
create an ER table
Dr. Jones, knowing that you are an intuitive database design student, has come to you with a possible database solution for his medical practice. He is interested in storing data related to his patients and the medications that they take. He specifically would like to keep track of the drug names, the drug price, the dosage each patient takes, and the dates that the medications were prescribed. He needs to be able to pull patient data quickly to make sure that each patient is taking the least medication to help their illness. Create business rules that might go with this scenario. Keep in mind that nouns (subjects) will become entities and their characteristics attributes. Verbs will translate into the relationships between entities. Create the ER diagram using Visio that would go with this scenario. Be sure to include entities, attributes, keys, and relationships using the crow’s feet notation
Consider the unnormalized data presented in the STUDENT table below:a) Identify the data redundancies and give reasons why they create problems in schemas. STUNUM STUNAME TUTNUM TUTNAME COURSENUM COURSEDESC GRADE 00118536 John Brown RC985 Rose Carter CS1001 CS1002 CS1003 Comp Research English Database design B A A 00118537 Marie Smith TB526 Tom Black CS9001 CS9002 CS1002 Calculus Javascript English A B C 00118538 Mary Cole PF587 Peter Finch CS9002 CS1003 CS1001 Javascript Database design Comp Research C A A 00118539 Ian Dunkley SH231 Sarah Hardy CS9005 CS9006 CS1002 Information Systems Web Design English A B B 00118540 Bob Marley JH850 Jacqui Hart CS9002 CS1002 CS1003 JavaScript English Database Deign A B C b) Which dependencies represent 1NF violations? Identify and eliminate 1NF violations. Present your table(s) after transformation into 1NF.c) Identify and remove any 2NF violations. Show the resulting schemas and tablesd) Identify and…
A DreamHome database has following tables. Branch (branchNo, street, city, postcode) Staff (staffNo, fName, lName, position, sex, DOB, salary, branchNo) PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo) PrivateOwner (ownerNo, fName, lName, address, telNo) Which is the correct relational algebra to express the following query? List the city and street of all branches which assistant staff’s salary is not greater than 9000 and age is at least 31. ( ) $$\Pi_{branchNo,street,city}(\sigma_{position='assistant' \wedge salary≤9000 \wedge DOB>'1-Jan-1990'} (Staff \bowtie Branch))$$ ( ) $$\sigma_{branchNo,street,city}(\Pi_{position=’assistant’ \wedge salary≤9000 \wedge DOB>’1-Jan-1990’}(Staff \cap Branch))$$ ( ) $$\sigma_{branchNo,street,city}(\sigma_{position=’assistant’ \wedge salary<9000 \wedge DOB>31}(Staff \bowtie Branch))$$ ( ) $$\Pi_{branchNo,street,city}(\sigma_{position=’assistant’ \wedge salary≤9000 \wedge…
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…