Theory Questions 1. The Kyrgios Database Group has about 120 employees. Each employee has an ID,...

Theory Questions 1.

The Kyrgios Database Group has about 120 employees. Each employee has an ID, a firstname and a surname. Each employee belongs to a department. The organisation has around 6 departments. Each department has a department code and a departmentname. • Create an ERD solution based on the above narrative. ERD Diagram

Question 2.

The Tomic Primary School wishes to democratically choose which animal will become the school mascot. The list of alternatives includes Kangaroo, Koala, Tiger, Elephant, Parrot, Penguin… Each student may vote for one or more of the animals to be the mascot. Each student has a student Id and name. Each of the animals has been assigned a numeric id and name (e.g. 7 Tiger). The school want to be able to store all of the votes made by students in a database. • Create an ERD solution based on the above narrative. ERD Diagram

Expert Solution

venereology answered 1 year ago

Consider the following relational database schema: employee(employee-name, employee-id, street, e-city) works(employee-

Consider the following relational database schema: employee(employee-name, employee-id, street, e-city) works(employee-id, company-id, salary) company(company-name, company-id, c-city) manages(employee-id, manager-id) Specify the following queries on this database schema using the relational operators we discussed in class. Write your answers on a separate sheet of paper in the order that they are specified below. Retrieve the name and address of employees who work for First Bank Corporation. Retrieve the name, street address, and city of residence of all employees...

List department name, employee id, and employee name for all employees in department name order. Repeat...

List department name, employee id, and employee name for all employees in department name order. Repeat for department #10 only. List the course ID, course name, section, instructor name, day, time, and room for all course sections. List the course ID, course name, section, student ID, and student name for CRN 1003. Display the list in ascending order of student last and first names. DROP TABLE registration; DROP TABLE sections; DROP TABLE courses; DROP TABLE students; DROP TABLE instructors; CREATE...

If a company provides a group hospitalization insurance plan for all employees and charges each employee...

If a company provides a group hospitalization insurance plan for all employees and charges each employee for the premium. The premium is $7,000 for each employee, and none of the employees can deduct the medical insurance from their taxes since they do not meet the 7 1/2 percent floor. The company is considering paying for employees insurance next year in place of raises. If the company adopts this change, the employee's after-tax and insurance pay will: a. Decrease by the...

5 people from group are given an ID ranging from 1-9 independent from each other's ID....

5 people from group are given an ID ranging from 1-9 independent from each other's ID. What is the probability that at least 2 people share an ID number?

Write a program of doubly Circular linked list to maintain records of employees. Take employee ID,...

Write a program of doubly Circular linked list to maintain records of employees. Take employee ID, name and salary as data of each employee. Search a particular record on ID and display the previous and next records as well. Whichever ID it give, it should display all the records because of being circular. Code needed in Java.

About the organization: This fictional organization has a small, but growing, employee base, with 50 employees...

About the organization: This fictional organization has a small, but growing, employee base, with 50 employees in one small office. The company is an online retailer of the world's finest artisanal, hand-crafted widgets. They've hired you on as a security consultant to help bring their operations into better shape. Organization requirements: As the security consultant, the company needs you to add security measures to the following systems: An external website permitting users to browse and purchase widgets An internal intranet...

Create a class called employee which has the following instance variables: Employee ID number Salary Years...

Create a class called employee which has the following instance variables: Employee ID number Salary Years at the company Your class should have the following methods: New employee which reads in an employee’s ID number, salary and years of service Anniversary which will up the years of service by 1 You got a raise which will read in how much the raise was (a percent) and then calculate the new salary You get a bonus which gives a yearly bonus...

In R-Syntax, create a vector of 100 employees ("Employee 1", "Employee 2", ... "Employee 100") [Hint:...

In R-Syntax, create a vector of 100 employees ("Employee 1", "Employee 2", ... "Employee 100") [Hint: use the `paste()` function and vector recycling to add a number to the word "Employee"] then create a vector of 100 random salaries for the year 2017 [Use the `runif()` function to pick random numbers between 40000 and 50000] and finally create a vector of 100 salary adjustments between -5000 and 10000 [use runif() to pick 100 random #'s in that range]

A) Using the scenario described by “Each store employs one or more employees; each employee is...

A) Using the scenario described by “Each store employs one or more employees; each employee is employed by one store”, work the following problems: 1. Identify each entity. 2. Identify each relationship type. Justify your answer. 3. Create the basic Crow's Foot ERD using Visio. B) Using the scenario described by “A job assignment can be assigned to more than one employee at a time; each employee can have only one job assignment”, work the following problems: 1. Identify each...

A company database needs to store information about employees (identiﬁed by ssn, with salary and phone...

A company database needs to store information about employees (identiﬁed by ssn, with salary and phone as attributes), departments (identiﬁed by dno, with dname and budget as attributes), and children of employees (with name, age, and relationship to the employee as attributes). Employees work in departments; each department is managed by an employee; a child must be identiﬁed uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We...

Question