(1)Suppose that you find a job in the Human Resources Department of The DreamCompany.
Yo...
Computers and Technology, 12.02.2020 03:30, marchellamazz123
(1)Suppose that you find a job in the Human Resources Department of The DreamCompany.
You are responsible for building a database to store various information about the employees,
departments, and so on. In this part of the project, you will complete a conceptual design using
ER/EER data model for a much simplifed HR database based on the following set of requirements:
The employees work in departments for some projects.
An employee can work on multiple projects that may be participated by several departments.
Any employee can only be either a salariedEmp or an hourlyEmp but not both. An employee is uniquely identified by a ssn. We should record dob(date of birth), name, and address of the employee. Name is composed of Fname, Minit, and Lname.
A salariedEmp has a monthly salary and an hourlyEmp has a rate of hourPay.
An employee may have dependents (described by name, and relationship). Dependents of different employees may have the same names.
Each department, identified by deptNum, has deptName and one or more locations. The numEmp (number of employees) can be regarded as a calculated attribute of the department.
A department has a manager who is also a salaried employee.
A project is identified by projName and projNum together. It has a description (projDesc).
(2)Relational Schema Design
Continuing at the corrected version of part #1,
Specify the domains of each attribute listed by relations. If you have special considerations such as Nullness and uniqueness, please point out.
Add semantic checks. SSN must be exactly nine digits, and hourPay must be at least $7.50.
Convert your ER/EER diagram into relational tables.
Specify the entity constraints (by underlining) and referential integrity constraints (by FK-PK relationship arrows).
(3)In this part, you will implement your relational schema designed in part #2 using a commercial database, insert some tuples into the tables and query the database. You can use WAMPS/MAMP/LAMP or SQL server (or Oracle or any other databases).
1. Create the tables. Submit your SQL scripts of CREATE TABLE commands. Enforce key and referential integrity constraints and any other constraints you have (e. g. unique, not null, check etc.).
2. Insert into each table 4 records. Submit your INSERT commands and the final result of running "select * from YOUR_TABLE" for each of your tables (hint: you can cut and paste to a WORD document named as YOUR_LOGIN_prj3.doc as a submission for example). You can insert 10 records for one or two tables to look at more interesting query results.
3. Update a record in one table. Update potentially several records at once using subqueries. Show the records after updating.
4. Query your database. Submit the SQL scripts of five queries into the tables together with their running results. At least one query includes join operation; one has subquery in it; one has group by and having in it; one has set operation (union , intersect or except) in it. Submit the hardcopy.
Answers: 3
Other questions on the subject: Computers and Technology
Computers and Technology, 21.06.2019 16:20, daniecott
Quincy would like to view the contents of a specific message in his inbox. a portion of his computer screen is shown. what should quincy do in order to complete this task? 1. click on the inbox in the navigation pane, and click on the specific message in the folder pane to display its contents. 2. click on the inbox in the outlook today window, and click on the specific message in the folder pane to display its contents. 3. double-click the message’s header in the outlook today window, and right-click on the specific message to display its contents. 4. double-click the mail option in the navigation pane, and right-click on the specific message to display its contents.
Answers: 1
Computers and Technology, 22.06.2019 20:10, ianmartin6080
Assume that minutes is an int variable whose value is 0 or positive. write an expression whose value is "undercooked" or "soft-boiled" or "medium-boiled" or "hard-boiled" or "overcooked" based on the value of minutes. in particular: if the value of minutes is less than 2 the expression's value is "undercooked"; 2-4 would be a "soft-boiled", 5-7 would be "medium-boiled", 8-11 would be "hard-boiled" and 12 or more would be a "overcooked".
Answers: 1
Computers and Technology, 22.06.2019 22:20, kaiyerecampbell95
Pp 4.1 design and implement a class called sphere that contains instance data that represents the sphere’s diameter. define the sphere constructor to accept and initialize the diameter and include getter and setter methods for the diameter. include methods that calculate and return the volume and surface area of the sphere (see pp 3.5 for the formulas). include a tostring method that returns a one-line description of the sphere. create a driver class called multisphere, whose main method instantiates and updates several sphere objects.
Answers: 1
Computers and Technology, 23.06.2019 09:20, lovely222
How to print: number is equal to: 1 and it is odd number number is equal to: 2 and it is even number number is equal to: 3 and it is odd number number is equal to: 4 and it is even number in the console using java using 1 if statement, 1 while loop, 1 else loop also using % to check odds and evens
Answers: 3
Do you know the correct answer?
Questions in other subjects:
Mathematics, 18.10.2019 06:30
Business, 18.10.2019 06:30
History, 18.10.2019 06:30
Mathematics, 18.10.2019 06:30
Social Studies, 18.10.2019 06:30
