Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table is employee statistics for IT Excellence company Employeeld 10 105 152 215 244 300 335 400 441 EmployeeName Sulaiman Ali Khairul Anuar

image text in transcribed
image text in transcribed
The following table is employee statistics for IT Excellence company Employeeld 10 105 152 215 244 300 335 400 441 EmployeeName Sulaiman Ali Khairul Anuar Tan Ah Meng Sivakumar Sufian Ahmad Alina Ali Junainah Johan Stephanie Chua Muthusamy Salary (RM) 75000 65000 60000 60000 50000 45000 40000 32000 28000 Position Manager Manager Manager Manager Staff Staff Staff Entry Level Entry Level Based on given table, Change the salary of Alina Ali to RM45,500 A UPDATE Employee stats MODIFY Salary(RM) - 45000 WHERE EmployeeName = 'Alina All B. ALTER TABLE Employee stats MODIFY Salary (RM) - 45000 WHERE EmployeeName = 'Alina All C.UPDATE Salary(RM) - 45000 WHERE EmployeeName 'Alina All's OD UPDATE Employee_stats Set Salary(RM) - 45000 WHERE EmployeeName 'Alina All When mapping a complex relationship type, the following statements are true, EXCEPT? Student StudentiD (PK) 11 Register UnivStaff 1.1 StaffiD (PK) Institution InstitutionID (PK) A. Copy foreign key attribute(s) of Univstoff to act as primary key for Student entity B. Transform many-to-many relationship by creating a new entity and binary relationships between original entities with this new entity c. Create Registration relation to represent relationship and include studenti, Staff and Institution that are part of the relationship D. Create relations for Student, Institution and Univstatt entities following appropriate rules for binary relationship

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Time Series Databases New Ways To Store And Access Data

Authors: Ted Dunning, Ellen Friedman

1st Edition

1491914726, 978-1491914724

More Books

Students also viewed these Databases questions