Homework ✓ Solved

Homework Page HW-6 MEHW-18 A spring has a constant of k = 50 lb/ft. Calculate the work necessary to compress the spring 6 inches from its uncompressed position. A. 300 ft-lb B. 25 ft-lb C.

6.25 ft-lb D. 1.25 ft-lb MEHW-19 Steam enters an ideal turbine at 600 psia and a temperature of 600° F. If the steam exhausts to a condenser operating at 90° F, what is the enthalpy of the exhaust steam? A. 839.3 BTU/lb B.

885.2 BTU/lb C. 924.3 BTU/lb D. 1042.7 BTU/lb MEHW-20 Find the quality of the exhaust steam if the turbine in the previous problem was 90% efficient, rather than ideal. A. 70% B.

75% C. 79% D. 90% MEHW-21 Determine the total horizontal force of the water acting on the dam shown below. The dam is 10 feet long and the water is 8 feet deep. A.

277 lb B. 499 lb C. 19,970 lb D. 39,940 lb Homework Page HW-7 MEHW-22 a and a 6-inch diameter piston at point b. Find the hydraulic pressure and the force F that can be lifted by the jack when a force P = 25 lbs is applied to the handle as shown.

A. 125 lb B. 250 lb C. 1125 lb D. 4000 lb MEHW-23 A 1 kW heating coil is submerged in ½ gallon of 60° F water.

What will be the final water temperature if the coil operates for 10 minutes and all its heat is transferred to the water? A. 122° F B. 176° F C. 196° F D.

212° F Boiling MEHW-24 The theoretical maximum efficiency of a cyclic heat engine: A. depends on the amount of friction in the cycle B. depends on the working fluid used in the cycle C. depends on the maximum and minimum temperatures in the cycle D. is 100% MEHW-25 A four cylinder, 4-stroke, internal combustion engine has a bore of 4 inches and a stroke of 3 inches. If the engine develops, 65 hp at 900 rpm, find the brake mean effective pressure. A. 202 psi B. 251 psi C.

314 psi D. 379 psi Homework Page HW-8 MEHW-26 4,000 cu ft/min of water is available for use in a hydroelectric turbine. If the vertical drop of the water is 20 feet, and it enters and leaves the turbine at the same velocity and temperature as it enters, how much would be produced by a 100% efficient turbine? A. 14.5 hp B.

75.6 hp C. 121 hp D. 151 hp MEHW-27 A 1 cubic foot block of an unknown material displaces ¾ cubic feet when it floats in a liquid, with a specific gravity of 0.92. How much does this block of unknown material weigh? A.

43 lbs B. 56 lbs C. 69 lbs D. 92 lbs MEHW-28 A pile driver, with a 1000 lb hammer, drops five feet each time it strikes. Find the velocity of the hammer just prior to striking the pile.

A. 15.2 ft/sec B. 17.9 ft./sec C. 21.3 ft/sec D. 24.7 ft/sec MEHW-29 If the pile driver, in the previous problem, drives the pile 6 inches into the ground with each stroke of the hammer, find the average force acting on the pile.

A. 1,000 lbs B. 5,000 lbs C. 10,000 lbs D. 12,000 lbs Assessment Brief: BIS1002 Data and Information Management Trimester-1 2021 Assessment Overview Assessment Task Type Weighting Due Length ULO Assessment 1: Database Interrogation Practical exercises assess students’ ability to apply theoretical learning to practical, real world situations on a weekly basis.

Individual 40% Weeks 2, 4, 6, 8, words ULO-1 ULO-2 ULO-3 ULO-4 Assessment 2: Applied Project -1 Design a relational database system for a specify organization. The design covers ERD, modelling the rules of organisation, entities and attributes and relationships. Individual 30% Week 7 2500 words ULO-1 ULO-2 ULO-3 Assessment 3: Applied Project –2 Design and implement and physical data-based system according to specified requirements. The design convers the process of logical and physical design. The students have to implement the proposed design and demonstrate the use of SQL language.

Group 30% Week words ULO-1 ULO-2 ULO-3 ULO-4 Assessment 1: Database Interrogation Due date: Weeks 2, 4, 6, 8, 10 Group/individual: Individual Word count / Time provided: 2500 words Weighting: 40% Unit Learning Outcomes: ULO-1, ULO-2, ULO-3, ULO-4 Assessment Details: Database Interrogation are practical exercises that assess students’ ability to apply theoretical learning to practical database questions. This assessment will improve student’s ability to design databases and write SQL queries. Students will not be assessed on work that the tutor has not seen them produce in class so that attendance is required as part of this assessment. Students are required to submit the work that they have completed during the lab session.

The details of the lab work and requirements are provided on the online learning system. Marking Information: The assessments will be marked out of 100 and will be weighted 40% of the total unit mark. Assessment 2: Applied Project-1 Due date: Week 7 Group/individual: Individual Word count / Time provided: 2500 words Weighting: 30% Unit Learning Outcomes: ULO-1, ULO-2, ULO-3 Assessment Details: Reline Engineering is an engineering firm with approximately 600 employees. A database is required to keep track of all employees, their skills, projects assigned, and departments worked in. Every employee has a unique number assigned by the firm and is required to store his or her name and date of birth.

If an employee is currently married to another employee of Reline Engineering., the date of marriage and who is married to whom must be stored; however, no record of marriage is required if an employee’s spouse is not also an employee. Each employee is given a job title (e.g., engineer, secretary, and so on). An employee does only one type of job at any given time, and we only need to retain information for an employee’s current job. There are 10 different departments, each with a unique name. An employee can report to only 1 department.

Each department has a phone number. To procure various kinds of equipment, each department deals with many vendors. A vendor typically supplies equipment to many departments. We are required to store the name and address of each vendor and the date of the last meeting between a department and a vendor. Many employees can work on a project.

An employee can work on many projects (Project A, Project B etc.), but he/she can only be assigned to at most one project in a given city. For each city, we are interested in its state and population. An employee can have many skills (preparing material requisitions, checking drawings, and so on), but she or he may use only a given set of skills on a particular project. (For example, an employee WILLIAMS may prepare requisitions for the Project D and prepare requisitions as well as check drawings for Project E.) Employees use each skill that they possess in at least one project. Each skill is assigned a number, and we must store a short description of each skill. Projects are distinguished by project numbers, and we must store the estimated cost of each project.

Your assignment consists of two parts. Part 1. Conceptual Model • Identify Entities • Identify entity supertypes and subtypes and their types, inheritance, and discriminators. • Describe relationships between entities and their cardinalities • Identify entity primary keys • Draw a Conceptual Model Entity-Relationship diagram Part 2. Logical Model • Describe data attributes and their types for each entity • Redesign the Conceptual model removing many-to-many relationships (if any) • Identify primary, composite (if any) and foreign keys (if any) for each entity • if there are any one-to-one relationships then describe them • Draw a Logical Model diagram Marking Information: The assessments will be marked out of 100 and will be weighted 30% of the total unit mark.

Marking Criteria Not satisfactory (0-49%) of the criterion mark) Satisfactory (50-64%) of the criterion mark Good (65-74%) of the criterion mark Very Good (75-84%) of the criterion mark Excellent (85-100%) of the criterion mark Demonstrate an understanding and describe the Conceptual Model design processes (20%) Inadequate understanding and describing Conceptual Model design process Basic knowledge only of understanding and describing Conceptual Model design process Exhibits breadth and depth of understanding and describing Conceptual Model design process Exhibits accurate and detailed breadth and depth of understanding and describing Conceptual Model design process Displays exceptional understanding of concepts and their practical application in Conceptual Model design process Demonstrate an understanding and describe the Logical Model design processes (20%) Inadequate understanding and describing Logical Model design process Basic knowledge only of understanding and describing Conceptual Exhibits breadth and depth of understanding and describing Conceptual Exhibits accurate and detailed breadth and depth of understanding and describing Displays exceptional understanding of concepts and their practical application in Model design process Model design process Conceptual Model design process Conceptual Model design process Demonstrate understanding and skills of creating the Conceptual Model diagram (30%) Inadequate understanding and skills of creating the Conceptual Model diagram Basic understanding and skills of creating the Conceptual Model diagram Exhibits breadth and depth of understanding and skills of creating the Conceptual Model diagram Exhibits accurate and detailed breadth and depth of understanding and skills of creating the Conceptual Model diagram Displays exceptional understanding and skills of creating the Conceptual Model diagram Demonstrate understanding and skills of creating the Logical model diagram (30%) Inadequate understanding and skills of creating the Logical Model diagram Basic understanding and skills of creating the Logical Model diagram Exhibits breadth and depth of understanding and skills of creating the Logical Model diagram Exhibits accurate and detailed breadth and depth of understanding and skills of creating the Logical Model diagram Displays exceptional understanding and skills of creating the Logical Model diagram Assessment 3: Applied Project-2 Due date: Week 12 Group/individual: Group Word count / Time provided: 2500 words Weighting: 30% Unit Learning Outcomes: ULO-1, ULO-2, ULO-3, ULO-4 The Trade Master company sells various tools.

It has sales offices and warehouses all over Australia. The company developed a data warehouse to store information about sales, customers and products. These data are stored in the AppliedProject2 Access file provided for you. The database consists of 6 tables: • CompanyDim – with the sales office address, state and email • ProductDim – product information • WarehouseDim – warehouse locations • CustomerDim – information about customers • DateDim – sales dates • SaleFacts – information about sales Please notice that all data (customers, sales, dates, warehouses and products) are randomly generated. Table and field names are self-explanatory.

The Global Trading company wants to retrieve information from the database for reporting and data analysis. You must do the following tasks 1. In the MS Word document: a. Analyse and describe the tables. b. Describe dimension and fact tables. (You need to remember that the Data Warehouse tables are organised into a fact and dimension tables, and this structure is called a database star schema). c.

Identify and describe primary and foreign keys. d. Draw the database diagram. e. Copy from the database all queries to the Word document and explain them. 2. In the SQLite Browser, you need to write, save and run the following SQL queries: a.

Create all primary and foreign keys. b. Insert a new customer. Devise your own data for this record. c. Create a new sale fact related to the new customer. You can choose any existing product, warehouse, date and sales office. d.

Display all customer names, their addresses and states. e. Display all customer names from Victoria. f. Display the total amount of all company sales in 2018. g. Display total amount of sales for each product separately. h. Display total amount of sales for each product and state separately, i.e. the output should contain 3 columns: product, state and total amount for this product and state. i.

Display products sold from warehouses located in Victoria. j. For each sale, display a customer name and a purchase date. k. Display a total number of sales (NOT AMOUNT!) for each customer. l. For each sales office (branch), display: branchKey, branch state, a customer name (a customer purchased in this office), a product name purchased by this customer, and a month number of the purchase. Your submission should consist of the following documents: • MS Word document containing answers to the Task 1 • SQLite Browser file with stored SQL queries from Task 2 Marking Criteria and Rubric: The assessment will be marked out of 100 and will be weighted 30% of the total unit mark Marking Criteria Not satisfactory (0-49%) of the criterion mark) Satisfactory (50-64%) of the criterion mark Good (65-74%) of the criterion mark Very Good (75-84%) of the criterion mark Excellent (85-100%) of the criterion mark Demonstrate understanding of database design and ability to draw database diagrams (20%) Inadequate understandin g of database design and database diagrams.

Basic knowledge only of understanding and of database design and database diagrams. Exhibits breadth and depth of understanding of database design and database diagrams. Exhibits accurate and detailed breadth and depth of understanding of database design and database diagrams. Displays exceptional understanding of database design and database diagrams. Demonstrate understanding of database primary and foreign keys, and database referential integrity. (10%) Inadequate understandin g of database primary and foreign keys, and database referential integrity.

Basic knowledge only of understanding of database primary and foreign keys, and database referential integrity. Exhibits breadth and depth of understanding of database primary and foreign keys, and database referential integrity. Exhibits accurate and detailed breadth and depth of understanding of database primary and foreign keys, and database referential integrity. Displays exceptional understanding of database primary and foreign keys, and database referential integrity. Demonstrate an understanding and ability to write and run simple SQL DDL and DML queries (20%) Inadequate understandin g and ability to write and run simple SQL DDL and DML queries Basic knowledge only of understanding and ability to write and run simple SQL DDL and DML queries Exhibits breadth and depth of understanding and ability to write and run simple SQL DDL and DML queries Exhibits accurate and detailed breadth and depth of and ability to write and run simple SQL DDL and DML queries Displays exceptional understanding and ability to write and run simple SQL DDL and DML queries Demonstrate understanding and skills of writing advanced SQL queries, including table joins, MS Access functions and aliases (50%) Inadequate understandin g and skills of creating the Conceptual Model diagram Basic understanding and skills of creating the Conceptual Model diagram Exhibits breadth and depth of understanding and skills of creating the Conceptual Model diagram Exhibits accurate and detailed breadth and depth of understanding and skills of creating the Conceptual Model diagram Displays exceptional understanding and skills of creating the Conceptual Model diagram

Paper for above instructions

Assignment Solution for Data and Information Management for Reline Engineering

Introduction
In the world of Information Technology and Engineering, data management plays a crucial role in the successful operation of any business. Reline Engineering, an engineering firm seeking to manage employee data, projects, skills, and vendor relations effectively, requires a relational database. This assignment outlines the two-part process of creating both a conceptual and logical model for a relational database system that meets the specified requirements.
Part 1: Conceptual Model
##### Entities Identification
In designing the conceptual model, identifying key entities is the first step. The entities for Reline Engineering include:
1. Employee: Attributes include EmployeeID (PK), Name, DateOfBirth, JobTitle.
2. Department: Attributes include DepartmentID (PK), DepartmentName, PhoneNumber.
3. Project: Attributes include ProjectID (PK), ProjectName, EstimatedCost.
4. Skill: Attributes include SkillID (PK), SkillDescription.
5. Vendor: Attributes include VendorID (PK), VendorName, Address, LastMeetingDate.
6. City: Attributes include CityID (PK), CityName, State, Population.
##### Relationships Between Entities
1. Employee and Department: Many employees can belong to one department, though one employee belongs to one department only. (1-to-Many)
2. Employee and Project: Many employees can work on one project, while one employee can only work on one project in a given city. (1-to-Many with a constraint)
3. Employee and Skill: Many employees can possess many skills, and one skill can belong to many employees. (Many-to-Many)
4. Department and Vendor: Many vendors can supply to many departments, implying a Many-to-Many relationship.
5. Project and City: Each project can be located in one city, while a city may have many projects associated with it. (1-to-Many)
##### Primary Keys Identification
- Employee: EmployeeID
- Department: DepartmentID
- Project: ProjectID
- Skill: SkillID
- Vendor: VendorID
- City: CityID
##### Conceptual Model Diagram
To represent the relationships visually and structure the entities, an Entity-Relationship Diagram (ERD) can be created. The diagram would illustrate entities as rectangles, primary keys as underlined text, relationships as diamonds, and cardinalities as annotations on lines connecting entities.
Part 2: Logical Model
##### Data Attributes and Their Types
1. Employee:
- EmployeeID: INT (PK)
- Name: VARCHAR(50)
- DateOfBirth: DATE
- JobTitle: VARCHAR(30)
2. Department:
- DepartmentID: INT (PK)
- DepartmentName: VARCHAR(50)
- PhoneNumber: VARCHAR(15)
3. Project:
- ProjectID: INT (PK)
- ProjectName: VARCHAR(50)
- EstimatedCost: DECIMAL(10,2)
4. Skill:
- SkillID: INT (PK)
- SkillDescription: VARCHAR(255)
5. Vendor:
- VendorID: INT (PK)
- VendorName: VARCHAR(50)
- Address: VARCHAR(100)
- LastMeetingDate: DATE
6. City:
- CityID: INT (PK)
- CityName: VARCHAR(50)
- State: VARCHAR(30)
- Population: INT
##### Redesign for Many-to-Many Relationships
To resolve many-to-many relationships, the following association tables will be introduced:
1. Employee_Skill:
- EmployeeID (FK)
- SkillID (FK)
2. Department_Vendor:
- DepartmentID (FK)
- VendorID (FK)
##### Primary, Composite, and Foreign Keys Identification
- EmployeeID, DepartmentID, ProjectID, SkillID, VendorID, CityID are primary keys.
- Employee_Skill and Department_Vendor will have composite keys with foreign key references to their respective entities.
##### One-to-One Relationships
Currently, there are no one-to-one relationships present in the relational model; each relationship is either one-to-many or many-to-many. However, if the design changes, modifications can be made accordingly based on emerging criteria.
##### Logical Model Diagram
A logical model diagram would be developed illustrating all adjustments made. This would entail creating tables and fields in the designed database and visual representations of the structure, ensuring normalization standards are met to prevent data redundancy.
Conclusion
The engineering firm Reline Engineering's need for an effective relational database system to manage employee skills, projects, departments, and vendors can be answered through the design of the conceptual and logical models provided. By clearly defining entities, relationships, and attributes, constructing a robust physical data model can be achieved, leading to better management of data resources for decision-making processes.
References
1. Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems. Pearson.
2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2011). Database System Concepts. McGraw-Hill.
3. Date, C. J., & Darwen, H. (2016). Database Design and Relational Theory. O'Reilly Media.
4. Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson.
5. Chester, M. (2018). Entity-Relationship Modeling. Journal of Database Management, 29(1), 1-18.
6. O'Neil, P., & O'Neil, E. (2002). Database: Principles, Programming, and Performance. Morgan Kaufmann.
7. Chen, P. P. (1976). The Entity-Relationship Model—Toward a Unified View of Data. ACM Transactions on Database Systems, 1(1), 9-36.
8. Rob, P., & Coronel, C. (2016). Database Systems Design, Implementation, & Management. Cengage Learning.
9. Teorey, T. J. (2011). Database Modeling and Design. Morgan Kaufmann.
10. Paulraj, P. (2020). Database Management Systems: Concepts, Techniques, and Applications. I.K. International Publishing House.