Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
(I) Using ER Assist Tool to draw the ER Diagram for the Company Database. The Requirements were discussed in the class.
(II) First using Oracle SQL * Plus, create the schema of this database. Continue by inserting the data records as presented in the handout. Note: You should print out the result of final tables.
(III) Solve the following queries in SQL. For each query, you need to specify the SQL and show the result of each query if applied to the Company Database.
(a) Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductX' project. (b) List the names of employees who have a dependent with the same first name as themselves. (c) Find the names of employees that are directly supervised by 'Franklin Wong'. (d) For each project, list the project name and the total hours per week (by all employees) spent on that project. (e) Retrieve the names of employees who work on every project. (f) Retrieve the names of employees who do not work on any project. (g) For each department, retrieve the department name, and the average salary of employees working in that department. (h) Retrieve the average salary of all female employees. (i) List the last names of department managers who have no dependents. (j) Specify a view that has the employee name, supervisor name, employee salary for each employee who works in the 'Research department.
Using the SafeAssign link in Blackboard to submit your report. Download and print out the FULL report and attach to the appendix at the back of your report. Assignments without the full SafeAssign report will NOT be marked.
Consider a relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Determine whether or not (A,E, F) is in BCNF and justify your answer. If (A,E, F) is not in BCNF,find a BCNF decomposition of it.
The marking scheme, which is given in detail below, particularly rewards the way in which you relate your specific proposals to the material presented in the Course.
Prepare a report that identifies the five most expensive bicycles. The report should list the bicycles in descending order from most expensive to lsit expensive, the quantity on hand for each, and the mark up percentage for each.
An academic department record points earned by individual students in their classes
Find the average number of books borrowed per member. Take into account that if a member does not borrow any books, then that member does not appear in the borrowed relation at all.
Transform the tables into one or more tables in BCNF. State the primary keys, candidate keys, and referential integrity constraints.
Construct a scenario leading to the worst-case performance of the FIFO buffer replacement policy - determine if it is conflict serializable or not
What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block of the next level down?
Create a context level DFD. You should take your DFD to your tutorial for feedback before starting on the ER.
The assignment will be chosen by the individual student with my approval. An ideal assignment will be one which involves at least four entity sets, but not too many since there will be critical time pressure to complete the assignment.
Sketch an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd