Computers and Technology

A startup company is using an excel spreadsheet to keep track of the billable hours that each employee spends on a project. As you can see, they are not data modelers. They would like to convert the spreadsheet into a database that they can use as a back end for a time keeping application. The column names of the spreadsheet are shown below:Project ID Project Name Project Manager Project Manager Location Employee ID Employee Name Employee Location Title Hourly Rate Billable HoursDraw a dependency diagram for the schema and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups. Here are the field descriptions: Project ID the identifier for the project Project Name the name of the project Project Manager the name of the project manager for a project, projects can have more than one project manager Project Manager Location location of the project manager Employee ID the identification number for an employee Employee Name the name of an employee Employee Location the location of an employee Title the position title for the employee Hourly Rate the rate that is charged to the project sponsor based on the position of the employee Hours worked the number of billable hours that an employee has charged to a project 2. Remove all partial and transitive dependencies and draw a new set of relations in third normal form. Put your thinking cap on because there are some obvious data management pitfalls associated with the above relation. 3. Draw the entity relationship diagram. 4. Based on your ERD, draw the physical data model including tables, attributes, data types, primary keys, and foreign keys.
Section 1.10 cites as a pitfall the utilization of a subset of the performance equation as a performance metric. To illustrate this, consider the following two processors. P1 has a clock rate of 4 GHz, average CPI of 0.9, and requires the execution of 5.0E9 instructions. P2 has a clock rate of 3 GHz, an average CPI of 0.75, and requires the execution of 1.0E9 instructions(a)One usual fallacy is to consider the computer with the largest clock rate as having the largest performance. Check if this is true for P1 and P2. (5pts)(b)Another fallacy is to consider that the processor executing the largest number of instructions will need a larger CPU time. Considering that processor P1 is executing a sequence of 1.0E9 instructions and that the CPI of processors P1 and P2 do not change, determine the number of instructions that P2 can execute in the same time that P1 needs to execute 1.0E9 instructions. (5pts)(c)A common fallacy is to use MIPS (millions of instructions per second) to compare the performance of two different processors, and consider that the processor with the largest MIPS has the largest performance. Check if this is true for P1 and P2. (5pts)(d)Another common performance figure is MFLOPS (millions of floating-point operations per second), defined asMFLOPS = No. FP operations / (execution time X IE6)But this figure has the same problems as MIPS. Assume that 40% of instructions executed on both P1 and P2 are floating-point instructions. Find the MFLOPS figures for the processors.
Create a java program that has a code file with main() in it and another code file with a separate class. You will be creating objects of the class in the running program, just as the chapter example creates objects of the Account class. Your system creates a registration bills for the billing part of a college. Create a class called Registration that holds the following information: first name, last name, number of credits, additional fees. The class should have all the gets and sets and also have a method to show the bill (with their name and the total which is 70 per credit + the additional fees) to the student. (You cannot have spaces in variable names. So you might call the first one firstName, first_name, fname or any other appropriate and legal variable name. The write up above is telling you the information to be stored in English, not java). Create 2 objects of Registration in your main code class and display the bills to the user with the method that shows the bill. Then add 3 credit hours to the first one, and subtract 3 credit hours from the second one and show the bills for both to the user again. (Hint: use the get) to read it out to a variable, add 3 (or subtract 3 for the second on), then use the set0 to store it back in replacing the old number of credit hours in the object.) (You can hard code the names, credit hours, and additional hours you are storing in the 2 Registration objects or ask the used for them with a Scanner. Either way is fine. It is perfectly all right from a grading standpoint to just give it test values like the chapter example does).