ELEC241 Programmable Logic Design Assignment 2 – Digital Clock Due: Monday 8th October 2017 11:55pm Total Marks: 100 Weighting: 10% of final grade Assignment 2 is a report on the design of your digital clock. You have spent many weeks developing this design, and you should now be in a position to write about the design. You have also implemented your design in class and can discuss the pitfalls discovered in the implementation. You are to write a report on your design. Your report should consist of the following sections: Introduction: Give a brief overview of your design. What were the design choices you made for 12/24 hour, time setting, and alarm functionality. Design and Equations: Present your design. Make reference to the CUPL equations. What were the major decisions you made during the design phase? How was the design achieved, how were the equations calculated? Development and Debugging: Critique your design and equations. What problems were discovered, and how were they solved? Over the course of the design and implementation your design may have changed. Why did it change? Was it in response to problems discovered, or an increase in the design complexity because of changed goals? Results/Alternatives Discussion: What alternative solutions were available? For each design decision you made describe the alternatives, and what criteria did you use to decide the design choice you made was the best possible. Appendix: Include the full CUPL listing for your design. Include a wiring diagram. The information in the appendix must be complete enough that the design can be implemented by somebody in possession of just the appendix. ELEC241 Assignment 2 2017 Session 2 Macquarie University Grading will take into consideration the level of discovery as evidenced by insight presented in the report in terms of critical evaluation of the practical activity and technical justification of procedure and design. Maximum length is six A4 pages excluding appendices. Clear, coherent and concise answers are preferred. The assignment will be submitted through ilearn. The marking rubric is as follows: High Distinction Grade: Including the features of a Distinction report, the report shows critical thinking in the evaluation of the circuits designed. It presents alternatives to each design if necessary, and explains why the chosen design was superior in at least one aspect, or otherwise clarifies why the eventual implementation was selected. It synthesises the design from the choices that were made during the pre-work for the earlier practicals. Distinction Grade: Including the features of a Credit report, the report evaluates the design as implemented for the clock. Each design is explained as to its functionality. The implementation of the design is clearly explained in terms of its equations and there is a critical evaluation of the design. Credit Grade: The report builds on the Pass grade by explaining the overall set of equations. It details how they work as a system, rather than individually. Pass Grade: The report details the design as chosen. It includes a copy of the CPUL equations and a wiring diagram in the appendicies, and explains what each equation does. ELEC241 Assignment 2 2017 Session 2 Macquarie University ELEC241 2017 Session 2 Assignment 2 detailed marking rubric: The marks for your report will be allocated as follows: Base mark: 0 if no submission 40: submitted a document, but does not satisfy the criteria for S1 50: S1: Details the physical connections, gives pin numbers or names. Piecemeal description of what each equation does, no integration in the report. 60: S2: S1 plus an overview of the full GALs. The report talks about how different equations work together to produce the complete solution. 70: S3: S2 plus breaks the design into subsystems and describes each (or a majority) of the subsystems. What works or doesn’t work about the equations. A description of the state machine that is implemented is provided. 80: S4: S3 plus presents alternatives for some subsystems. In addition to the base mark there are modifier marks for aspects of your report: -5 If there is no CUPL code present in the report. +1 to 3 Incomplete code – fragments are present, but not the entire code +4 Entire code included +1 Some comments included +2 to 3 Good comments, explaining what a section is doing rather than what a line is doing +1 Description of the pins used, grouped into input and output blocks -5 No wiring diagram included +2 Partial wiring diagram showing some connections +4 Complete wiring diagram +1 Each alternative presented in the discussion (This would usually mean an 80 base mark) +1 An explanation as to why the chosen alternative was selected +1 A GOOD explanation (1 extra mark ;-) Note: In this section the marker can award up to 3 marks for EACH good alternative. Finally, there are overall marks: -10 No Cover Sheet -10 to 0 If the discussion is poor for some reason the marker can deduct up to 10 marks -5 Not an engineering report. The report has to discuss any possible problems and how they are avoided/mitigated. -5 Discussion section overly long. More than 1 page over allowed length. Late Submission Penalty -20 Per Day or part thereof that the submission is late. ELEC241 Assignment 2 2017 Session 2 Macquarie University

ELEC241 Programmable Logic Design
Assignment 2 – Digital Clock
Due: Monday 8th October 2017 11:55pm
Total Marks: 100
Weighting: 10% of final grade
Assignment 2 is a report on the design of your digital clock. You have spent many weeks
developing this design, and you should now be in a position to write about the design. You have
also implemented your design in class and can discuss the pitfalls discovered in the implementation.
You are to write a report on your design.
Your report should consist of the following sections:
Introduction:
Give a brief overview of your design. What were the design choices you made for 12/24
hour, time setting, and alarm functionality.
Design and Equations:
Present your design. Make reference to the CUPL equations. What were the major decisions
you made during the design phase? How was the design achieved, how were the equations
calculated?
Development and Debugging:
Critique your design and equations. What problems were discovered, and how were they
solved? Over the course of the design and implementation your design may have changed. Why did
it change? Was it in response to problems discovered, or an increase in the design complexity
because of changed goals?
Results/Alternatives Discussion:
What alternative solutions were available? For each design decision you made describe the
alternatives, and what criteria did you use to decide the design choice you made was the best
possible.
Appendix:
Include the full CUPL listing for your design. Include a wiring diagram.
The information in the appendix must be complete enough that the design can be implemented by
somebody in possession of just the appendix.
ELEC241 Assignment 2 2017 Session 2
Macquarie University
Grading will take into consideration the level of discovery as evidenced by insight presented in the
report in terms of critical evaluation of the practical activity and technical justification of procedure
and design.
Maximum length is six A4 pages excluding appendices. Clear, coherent and concise answers are
preferred. The assignment will be submitted through ilearn.
The marking rubric is as follows:
High Distinction Grade:
Including the features of a Distinction report, the report shows critical thinking in the evaluation of
the circuits designed. It presents alternatives to each design if necessary, and explains why the
chosen design was superior in at least one aspect, or otherwise clarifies why the eventual
implementation was selected. It synthesises the design from the choices that were made during the
pre-work for the earlier practicals.
Distinction Grade:
Including the features of a Credit report, the report evaluates the design as implemented for the
clock. Each design is explained as to its functionality. The implementation of the design is clearly
explained in terms of its equations and there is a critical evaluation of the design.
Credit Grade:
The report builds on the Pass grade by explaining the overall set of equations. It details how they
work as a system, rather than individually.
Pass Grade:
The report details the design as chosen. It includes a copy of the CPUL equations and a wiring
diagram in the appendicies, and explains what each equation does.
ELEC241 Assignment 2 2017 Session 2
Macquarie University
ELEC241 2017 Session 2
Assignment 2 detailed marking rubric:
The marks for your report will be allocated as follows:
Base mark: 0 if no submission
40: submitted a document, but does not satisfy the criteria for S1
50: S1: Details the physical connections, gives pin numbers or names. Piecemeal
description of what each equation does, no integration in the report.
60: S2: S1 plus an overview of the full GALs. The report talks about how different
equations work together to produce the complete solution.
70: S3: S2 plus breaks the design into subsystems and describes each (or a majority)
of the subsystems. What works or doesn’t work about the equations. A
description of the state machine that is implemented is provided.
80: S4: S3 plus presents alternatives for some subsystems.
In addition to the base mark there are modifier marks for aspects of your report:
-5 If there is no CUPL code present in the report.
+1 to 3 Incomplete code – fragments are present, but not the entire code
+4 Entire code included
+1 Some comments included
+2 to 3 Good comments, explaining what a section is doing rather than what a line is doing
+1 Description of the pins used, grouped into input and output blocks
-5 No wiring diagram included
+2 Partial wiring diagram showing some connections
+4 Complete wiring diagram
+1 Each alternative presented in the discussion (This would usually mean an 80 base mark)
+1 An explanation as to why the chosen alternative was selected
+1 A GOOD explanation (1 extra mark 😉
Note: In this section the marker can award up to 3 marks for EACH good alternative.
Finally, there are overall marks:
-10 No Cover Sheet
-10 to 0 If the discussion is poor for some reason the marker can deduct up to 10 marks
-5 Not an engineering report. The report has to discuss any possible problems and how they
are avoided/mitigated.
-5 Discussion section overly long. More than 1 page over allowed length.
Late Submission Penalty
-20 Per Day or part thereof that the submission is late.
ELEC241 Assignment 2 2017 Session 2
Macquarie University

Read More

Sino-woodworks Ethiopia Ltd makes office furniture from fine hardwoods. The company uses a job-order costing system and predetermined overhead rates to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Preparation Department is based on machine-hours, and the rate in the Fabrication Department is based on direct materials cost. At the beginning of the year, the company’s management made the following estimates for the year: Job-C was started on April 1 and completed on May 12. The company’s cost records show the following information concerning the job: Required: a) Compute the predetermined overhead rate used during the year in the Preparation and Fabrication Departments. b) Compute the total overhead cost applied to Job-C. c) What would be the total cost recorded for Job-C? If the job contained 25 units, what would be the unit product cost? d) At the end of the year, the records of the company revealed the following actual cost and operating data for all jobs worked on during the year: What was the amount of under-applied or over-applied overhead in each department at the end of the year? —————————————————————————————————————————————— 3 | P a g e 3. Sino-electronics East-Africa Ltd manufactures electric meters for sale to its African and Middle-East customers. The product goes through three departments. The following information is available for the first department during June, 2014. Required: Assume that the company uses the weighted-average process costing. a) Determine the equivalent units for June for the first process. b) Compute the costs per equivalent unit for June for the first process. c) Determine the total cost of ending work in process inventory and the total cost of units transferred to the second process in June. d) Reconcile the total costs assigned to the ending work in process inventory and the units transferred out with the costs in beginning inventory and costs added during the period. 4. Sino-Afro Electronics manufactures different optical switch for networking uses in different industries. During 2013, the company completed an order for a special optical switch for a new customer, Ethio-telecom. This customer did not order any other products during the year. Data concerning that order follow: Data related to Ethio-telecom order Selling price $295 per unit Units ordered 100 units Direct materials $264 per unit Direct labor hours 0.50 hrs per unit Direct labor rate $25 per direct labor hr Currently, the company is concerned whether to accept this special order, thus, contracts your professional advice. The company traditionally uses direct labor hours to allocate manufacturing overhead costs. Total direct labor hours was estimated to be 20,000 in 2013. Other operating data for the year 2013 is provided in the following table. Note that 80% of the overhead costs are related to production while the remaining 20% are selling and administrative. —————————————————————————————————————————————— 4 | P a g e Required: a) Shall the company accept the special order if the traditional costing system is in use? Why? b) Shall the company accept the special order if activity-based costing system is in use? Why? c) Does the costing system affect your advice regarding acceptance of the special order

Sino-woodworks Ethiopia Ltd makes office furniture from fine hardwoods. The company uses a job-order costing system and predetermined overhead rates to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Preparation Department is based on machine-hours, and the rate in the Fabrication Department is based on direct materials cost. At the beginning of the year, the company’s management made the following estimates for the year:
Job-C was started on April 1 and completed on May 12. The company’s cost records show the following information concerning the job:
Required: a) Compute the predetermined overhead rate used during the year in the Preparation and Fabrication Departments. b) Compute the total overhead cost applied to Job-C. c) What would be the total cost recorded for Job-C? If the job contained 25 units, what would be the unit product cost? d) At the end of the year, the records of the company revealed the following actual cost and operating data for all jobs worked on during the year:
What was the amount of under-applied or over-applied overhead in each department at the end of the year?
—————————————————————————————————————————————— 3 | P a g e
3. Sino-electronics East-Africa Ltd manufactures electric meters for sale to its African and Middle-East customers. The product goes through three departments. The following information is available for the first department during June, 2014.
Required: Assume that the company uses the weighted-average process costing. a) Determine the equivalent units for June for the first process. b) Compute the costs per equivalent unit for June for the first process. c) Determine the total cost of ending work in process inventory and the total cost of units transferred to the second process in June. d) Reconcile the total costs assigned to the ending work in process inventory and the units transferred out with the costs in beginning inventory and costs added during the period.
4. Sino-Afro Electronics manufactures different optical switch for networking uses in different industries. During 2013, the company completed an order for a special optical switch for a new customer, Ethio-telecom. This customer did not order any other products during the year. Data concerning that order follow:
Data related to Ethio-telecom order Selling price $295 per unit Units ordered 100 units Direct materials $264 per unit Direct labor hours 0.50 hrs per unit Direct labor rate $25 per direct labor hr
Currently, the company is concerned whether to accept this special order, thus, contracts your professional advice. The company traditionally uses direct labor hours to allocate manufacturing overhead costs. Total direct labor hours was estimated to be 20,000 in 2013. Other operating data for the year 2013 is provided in the following table. Note that 80% of the overhead costs are related to production while the remaining 20% are selling and administrative.
—————————————————————————————————————————————— 4 | P a g e
Required: a) Shall the company accept the special order if the traditional costing system is in use? Why? b) Shall the company accept the special order if activity-based costing system is in use? Why? c) Does the costing system affect your advice regarding acceptance of the special order

Read More

This SLP consists of two parts: Part I: Return to the Health Literacy Education site at http://www.cdc.gov/healthliteracy/findtraining/onlinecourse.html and complete the training for “Creating Easier to Understand Lists, Charts, and Graphs” course. Once you are at this site, select the course from the list of available courses in the left-hand column. Complete the evaluation at the end, select “Print Certificate” and submit it to meet the requirements for Part I of your SLP assignment. Part II: You will apply the concepts you learned from the online CDC course by making a chart or table. To meet the requirement for Part II, create a simple illustration of the data you worked with in your Case 3 assignment. Options include a pie chart, table, or bar chart illustrating the data you worked with in your Case 3 assignment, and the display should be chosen based on what you learned about creating lists, charts, and graphs for public health communication. You may choose to use the Obesity data or the custom data you generated in Case 3 to make the visual illustration. SLP Assignment Expectations Create your chart, table, or graph in Excel, and then copy and paste it into a PowerPoint slide. Use the PowerPoint formatting and text tools to include a title and any other important information on your slide. Submit both the certification of completion of the CDC course, and your PowerPoint slide to your SLP dropbox by the module due date.

This SLP consists of two parts:

Part I: Return to the Health Literacy Education site at http://www.cdc.gov/healthliteracy/findtraining/onlinecourse.html and complete the training for “Creating Easier to Understand Lists, Charts, and Graphs” course. Once you are at this site, select the course from the list of available courses in the left-hand column.

Complete the evaluation at the end, select “Print Certificate” and submit it to meet the requirements for Part I of your SLP assignment.

Part II: You will apply the concepts you learned from the online CDC course by making a chart or table.

To meet the requirement for Part II, create a simple illustration of the data you worked with in your Case 3 assignment. Options include a pie chart, table, or bar chart illustrating the data you worked with in your Case 3 assignment, and the display should be chosen based on what you learned about creating lists, charts, and graphs for public health communication. You may choose to use the Obesity data or the custom data you generated in Case 3 to make the visual illustration.

SLP Assignment Expectations

Create your chart, table, or graph in Excel, and then copy and paste it into a PowerPoint slide. Use the PowerPoint formatting and text tools to include a title and any other important information on your slide. Submit both the certification of completion of the CDC course, and your PowerPoint slide to your SLP dropbox by the module due date.

Read More

NetLogo Assignment 3 Messaging (10% plus 10% bonus = 20%). Due on 11th October. Close-off 18th October. You should now be familiar with Netlogo and ready to apply your new found knowledge. You are to design a netlogo model of a messaging network (nodes and links) with the idea of seeing how a large file is saved and retrieved on a dispersed distributed network. You can think of the nodes as server components of a distributed network and consider local domains and so on. On this network file chunks pass between servers and are saved on chunk servers. I suggest you use the Google File System as a template for your model. The best way of starting out is to look at the network models in the NetLogo library (there are several suitable candidates). In this model, I want you to include Synchronisation considerations (as per this weeks lecture). For bonus marks add additional features of distributed networks covered in lectures for a maximum 10% additional marks. Bronze Level (70 marks): 1. What do you want to model (you had practice in doing requirements in the previous assignment). 2. Select candidate library models to consider for the basis of your messaging network model. Why did you select them? What effort is required to adapt them? 3. Devise a plan of how to build the model. The objective (subject to your interpretation) is to save a file, break it down in chunks, save it to chunk servers and then reverse the process. 4. How will you cater for modelling synchronisation? what type of synchronisation will you select for modelling and how would you track the synchronisation process? 5. What are your expectations for the model (inputs to change, outputs to monitor)? Silver and Gold Levels (30 marks): 1. Build the model. 2. Document your work. 3. Run the model and document your observations. Gold Level (20 marks): 1. Validate the model (does it work). 2. Document Issues and suggest improvements. 3. Assess the model for usefulness.

NetLogo Assignment 3 Messaging (10% plus 10% bonus = 20%).

Due on 11th October. Close-off 18th October.

You should now be familiar with Netlogo and ready to apply your new found knowledge. You are to design a netlogo model of a messaging network (nodes and links) with the idea of seeing how a large file is saved and retrieved on a dispersed distributed network.

You can think of the nodes as server components of a distributed network and consider local domains and so on. On this network file chunks pass between servers and are saved on chunk servers. I suggest you use the Google File System as a template for your model. The best way of starting out is to look at the network models in the NetLogo library (there are several suitable candidates).

In this model, I want you to include Synchronisation considerations (as per this weeks lecture).  For bonus marks add additional features of distributed networks covered in lectures for a maximum 10% additional marks.

Bronze Level (70 marks):

  1. What do you want to model (you had practice in doing requirements in the previous assignment).
  2. Select candidate library models to consider for the basis of your messaging network model. Why did you select them? What effort is required to adapt them?
  3. Devise a plan of how to build the model. The objective (subject to your interpretation) is to save a file, break it down in chunks, save it to chunk servers and then reverse the process.
  4. How will you cater for modelling synchronisation? what type of synchronisation will you select for modelling and how would you track the synchronisation process?
  5. What are your expectations for the model (inputs to change, outputs to monitor)?

Silver and Gold Levels (30 marks):

  1. Build the model.
  2. Document your work.
  3. Run the model and document your observations.

Gold Level (20 marks):

  1. Validate the model (does it work).
  2. Document Issues and suggest improvements.
  3. Assess the model for usefulness.

 

Read More

The State of Florida sold a total of 36.1 million lottery tickets at $1 each duringthe first week of January 2006. As prize money, a total of $41 million will be distributed($1,952,381 at the beginning of each year) over the next 21 years. Thedistribution of the first-year prize money occurs now, and the remaining lotteryproceeds will be put into the state’s educational reserve fund, which earns interestat the rate of 6% compounded annually. After making the last prize distribution (atthe beginning of year 21), how much will be left over in the reserve account?

The State of Florida sold a total of 36.1 million lottery tickets at $1 each duringthe first week of January 2006. As prize money, a total of $41 million will be distributed($1,952,381 at the beginning of each year) over the next 21 years. Thedistribution of the first-year prize money occurs now, and the remaining lotteryproceeds will be put into the state’s educational reserve fund, which earns interestat the rate of 6% compounded annually. After making the last prize distribution (atthe beginning of year 21), how much will be left over in the reserve account?

Read More

NIT1201 Introduction to Database SystemsAssignment Specification (30%) Individual work only. Due date: 23:59pm, week 12, Semester 2 2017 Submission via drop box on VU Collaborate only, no email submission will be accepted. Introduction The objective of this assignment is for you to put into practice the many different skills that you are learning in this unit into a single cohesive database project.You will be designing a database to meet a specific organisational need. To do this you will work through the various stages of database design, including identifying user requirements, developing an understanding of the entities required and the relationships between them, as well as identifying the business rules associated with the processes that are driving the need for the database. You will then develop appropriate data models and design and implement the database. You will demonstrate that your database implementation is viable through a series of queries and updates on the database.Scenario Western Melbourne University (WMU) requests you to work as a database designer to provide a database solution as part of its course enrolment system. The WMU Enrolment database (WMUED) is expected to store and maintain enrolment activities and records for all students in seven colleges: Arts, Science, Engineering, Business, Law, Education, and Information Technology. WMU accepts two intakes every year, one occurs in February and the other is in July. All colleges provide a number of Bachelor and Master courses. The Bachelor course normally take three years to complete for full-time students, except Engineering Bachelor courses require four years and Science Bachelor courses need five years. All Master courses take students two years to finish all requirements. Every year, students will have two semesters. Each semester, a full-time student with 100% study load needs to take four units. That is, for a three-year Bachelor course, students will complete 24 units; for a four-year Bachelor course, students will complete 32 units; and for a five-year Bachelor course will complete 40 units. A master course requires students to complete 16 units in total.When a new student is coming to WMU, some basic information will be collected and stored, such as full name, full home address, contact local number, mobile number, a personal email address, emergency contact person information (name, contact number, relationship). Students also need to provide previous education records, including qualification type, institute, and year of completion.Once a student enrol into a course in February, he or she needs to select at most four units (including part-time study load) for Semester 1and another four units for Semester two. Students are allowed to change their units four weeks before every semester starts. If a student enrols in July, then he or she only needs to select four units for Semester 2. Re-enrolment for both semesters will be opened next year. Each unit only is only offered in one semester, which means Unit X is offered in Semester 1, but not in Semester 2; and Unit Y is offered in Semester 2, then it will not be offered in Semester 1. Once students successfully enrol into the required units, he or she will be given a list of the enrolled units and fees to pay for the coming semester. The payment is requested for one semester, up to four units at most. Each unit will charge from $2500 to $4000 accordingly. The units are recorded by unit code and unit name. A unit code is assigned to a particular unit only. Same rule is applied on course code as well. A unit will be taught by one lecturer and one or moretutors. The lecturer can work as a tutor too. According to the number of the enrolled students, one or more labs will be offered in one unit. Each lab will be taken by a tutor. One tutor can take more than one lab. Each lab has a capability to have at most 30 students. The teaching allocation of all lecturers and tutors will be saved in each semester. Their basic information, their class allocation information (including unit to teach, class type, time starts, time ends, room location, etc.) are collected as well. All students will take lecture at the same time, but labs may not start for the same time. According to different units, a lecture lasts for one to two hours; and a lab takes from one, two or three hours. Each unit requires students to finish a number of assessment tasks, including lab exercises, tests, assignments, reports, in-class activities, practical demonstrations, and examinations. The results of all the assessments will be recorded. Grades will be granted based on the final results using the following rules:? N – under 50 ? P – 50 to 59 ? C – 60 to 69 ? D – 70 to 79 ? HD – 80 or aboveAll students will receive a report of their results of the enrolled units three weeks after the examination. In the report, the student information, course information, unit information, the final marks of each unit and corresponding grades will be sent to students via their university email and SMS to their mobile phones. A unit review report will be available for lecturers to access to evaluate student performance. Your task You have been commissioned to develop a database system that is capable of growing as WMUED does.The database needs to keep a record of:• All student basic information • All staff basic information • All student enrolment information • All teaching allocation • All assessments and results • Timetable for all units in both semestersFurther, it should be possible to generate a report on:• Course enrolment including number of students who enrol newly or continuously • Unit enrolment including number of students who enrol newly or repeat • Teaching staff allocation including staff information, class type, time and room location • Assessment results of individual students for all enrolled units • Student performance of a particular unit including all assessment results and final marks, sorted based on grades and surnamesSteps you need to take to develop your database application1. Complete the analysis and design of your database applicationa. List the business rules for your system (do not get distracted by red herrings in the scenario!).b. Identify the entities and relationships in your system. c. Identify the characteristics of the entities in your system. d. Develop an ER diagram to model your system. e. Develop table structures from the ER model. f. Conduct a dependency analysis of the table structures and normalize your tables where appropriate, to at least 3NF. g. Create a data dictionary for your database.2. Implement your projecta. Create a database that hosts your application data b. Create tables in your database. These must be consistent with your design. c. Populate all tables with sample data (at least 5 entries in each) d. Create the required views, stored procedures etc. to meet the requirements of your systemYou need to be able to demonstrate that your database application meets the requirements detailed in the scenario as well as be consistent with the model you have developed.Submission Requirements Your assignment should be composed of the following parts:1. Project document which includes the following:1.1. A list of the business rules; 1.2. ER Diagram(s) prepared using software such as MS Office Visio or any other ER diagram tool. These should include all necessary information about the entities, attributes and relationships. Please provide clear and easy-to-read screenshot of your ER Diagram(s). If you draw your diagram(s) in MS Visio, please submit the Visio file too; 1.3. Data dictionary in the format shown in the lecture notes; 1.4. Database design and table structures showing table names, as well as any related entity integrity and referential integrity constraints. Include in the table structures attribute data types, sizes, primary keys, foreign keys and any other relevant information; 1.5. Diagrams showing the dependency analysis for each of the tables. You need to demonstrate that all tables are in 3NF. Show the process of normalization including tables in 1NF, 2NF and 3NF respectively. Please refer to the examples in lecture notes; 1.6. The SQL code you used to: 1.6.1. Create and populate the database; 1.6.2. Create each of the reports identified in the assignment specification.2. Database implementation in XAMPP 2.1. All the tables of your assignment must be implemented in XAMPP. Please provide screenshots as evidence of your implementation. 2.2. All the tables must be well defined with appropriate primary keys and foreign keys where applicable. Please provide screenshot of table structures. 2.3. All tables must be populated with sample data (at least 10 entity instances

NIT1201 Introduction to Database SystemsAssignment Specification (30%) Individual work only. Due date: 23:59pm, week 12, Semester 2 2017 Submission via drop box on VU Collaborate only, no email submission will be accepted. Introduction The objective of this assignment is for you to put into practice the many different skills that you are learning in this unit into a single cohesive database project.You will be designing a database to meet a specific organisational need. To do this you will work through the various stages of database design, including identifying user requirements, developing an understanding of the entities required and the relationships between them, as well as identifying the business rules associated with the processes that are driving the need for the database. You will then develop appropriate data models and design and implement the database. You will demonstrate that your database implementation is viable through a series of queries and updates on the database.Scenario Western Melbourne University (WMU) requests you to work as a database designer to provide a database solution as part of its course enrolment system. The WMU Enrolment database (WMUED) is expected to store and maintain enrolment activities and records for all students in seven colleges: Arts, Science, Engineering, Business, Law, Education, and Information Technology. WMU accepts two intakes every year, one occurs in February and the other is in July. All colleges provide a number of Bachelor and Master courses. The Bachelor course normally take three years to complete for full-time students, except Engineering Bachelor courses require four years and Science Bachelor courses need five years. All Master courses take students two years to finish all requirements. Every year, students will have two semesters. Each semester, a full-time student with 100% study load needs to take four units. That is, for a three-year Bachelor course, students will complete 24 units; for a four-year Bachelor course, students will complete 32 units; and for a five-year Bachelor course will complete 40 units. A master course requires students to complete 16 units in total.When a new student is coming to WMU, some basic information will be collected and stored, such as full name, full home address, contact local number, mobile number, a personal email address, emergency contact person information (name, contact number, relationship). Students also need to provide previous education records, including qualification type, institute, and year of completion.Once a student enrol into a course in February, he or she needs to select at most four units (including part-time study load) for Semester 1and another four units for Semester two. Students are allowed to change their units four weeks before every semester starts. If a student enrols in July, then he or she only needs to select four units for Semester 2. Re-enrolment for both semesters will be opened next year. Each unit only is only offered in one semester, which means Unit X is offered in Semester 1, but not in Semester 2; and Unit Y is offered in Semester 2, then it will not be offered in Semester 1. Once students successfully enrol into the required units, he or she will be given a list of the enrolled units and fees to pay for the coming semester. The payment is requested for one semester, up to four units at most. Each unit will charge from $2500 to $4000 accordingly. The units are recorded by unit code and unit name. A unit code is assigned to a particular unit only. Same rule is applied on course code as well. A unit will be taught by one lecturer and one or moretutors. The lecturer can work as a tutor too. According to the number of the enrolled students, one or more labs will be offered in one unit. Each lab will be taken by a tutor. One tutor can take more than one lab. Each lab has a capability to have at most 30 students. The teaching allocation of all lecturers and tutors will be saved in each semester. Their basic information, their class allocation information (including unit to teach, class type, time starts, time ends, room location, etc.) are collected as well. All students will take lecture at the same time, but labs may not start for the same time. According to different units, a lecture lasts for one to two hours; and a lab takes from one, two or three hours. Each unit requires students to finish a number of assessment tasks, including lab exercises, tests, assignments, reports, in-class activities, practical demonstrations, and examinations. The results of all the assessments will be recorded. Grades will be granted based on the final results using the following rules:? N – under 50 ? P – 50 to 59 ? C – 60 to 69 ? D – 70 to 79 ? HD – 80 or aboveAll students will receive a report of their results of the enrolled units three weeks after the examination. In the report, the student information, course information, unit information, the final marks of each unit and corresponding grades will be sent to students via their university email and SMS to their mobile phones. A unit review report will be available for lecturers to access to evaluate student performance. Your task You have been commissioned to develop a database system that is capable of growing as WMUED does.The database needs to keep a record of:• All student basic information • All staff basic information • All student enrolment information • All teaching allocation • All assessments and results • Timetable for all units in both semestersFurther, it should be possible to generate a report on:• Course enrolment including number of students who enrol newly or continuously • Unit enrolment including number of students who enrol newly or repeat • Teaching staff allocation including staff information, class type, time and room location • Assessment results of individual students for all enrolled units • Student performance of a particular unit including all assessment results and final marks, sorted based on grades and surnamesSteps you need to take to develop your database application1. Complete the analysis and design of your database applicationa. List the business rules for your system (do not get distracted by red herrings in the scenario!).b. Identify the entities and relationships in your system. c. Identify the characteristics of the entities in your system. d. Develop an ER diagram to model your system. e. Develop table structures from the ER model. f. Conduct a dependency analysis of the table structures and normalize your tables where appropriate, to at least 3NF. g. Create a data dictionary for your database.2. Implement your projecta. Create a database that hosts your application data b. Create tables in your database. These must be consistent with your design. c. Populate all tables with sample data (at least 5 entries in each) d. Create the required views, stored procedures etc. to meet the requirements of your systemYou need to be able to demonstrate that your database application meets the requirements detailed in the scenario as well as be consistent with the model you have developed.Submission Requirements Your assignment should be composed of the following parts:1. Project document which includes the following:1.1. A list of the business rules; 1.2. ER Diagram(s) prepared using software such as MS Office Visio or any other ER diagram tool. These should include all necessary information about the entities, attributes and relationships. Please provide clear and easy-to-read screenshot of your ER Diagram(s). If you draw your diagram(s) in MS Visio, please submit the Visio file too; 1.3. Data dictionary in the format shown in the lecture notes; 1.4. Database design and table structures showing table names, as well as any related entity integrity and referential integrity constraints. Include in the table structures attribute data types, sizes, primary keys, foreign keys and any other relevant information; 1.5. Diagrams showing the dependency analysis for each of the tables. You need to demonstrate that all tables are in 3NF. Show the process of normalization including tables in 1NF, 2NF and 3NF respectively. Please refer to the examples in lecture notes; 1.6. The SQL code you used to: 1.6.1. Create and populate the database; 1.6.2. Create each of the reports identified in the assignment specification.2. Database implementation in XAMPP 2.1. All the tables of your assignment must be implemented in XAMPP. Please provide screenshots as evidence of your implementation. 2.2. All the tables must be well defined with appropriate primary keys and foreign keys where applicable. Please provide screenshot of table structures. 2.3. All tables must be populated with sample data (at least 10 entity instances

Read More

Gafat Engineering Ethio Plc manufactures two types of TV sets – LCD and CRT – both having only one model. The LCD and CRT television sets sell for Br 9,000 and Br5,000, respectively. The company sells its products through its own stores and other outlets. Total fixed expenses are Br15,000,000 per month. Variable expenses and monthly sales data are given below: LCD CRT Variable expenses Br5,000 Br2,000 Monthly sales in units 2,000 3,000 Required: ( unless stated figures should be computed for one month ) a) Determine breakeven total volume of sales and sales volume for each product. b) Determine sales volume and sales revenue for the company to earn Br500,000 profit after 30% profit tax. c) The company has planned to incur Br 200,000 monthly selling (promotional) expenses to increase sales volume for its LCD TV sets to 4,000. If the plan materializes and other things remain constant, determine breakeven sales volume and sales revenue for the company. d) The company has planned to buy new and improved technology that reduces variable production expenses for its LCD TV set to Br4,000 while increasing its monthly fixed production costs by Br500,000. If the plan materializes and other things remain constant, determine breakeven sales volume and sales revenue for the company. e) If the company is guaranteed with total sales volume of 10,000 TV sets in a given month, should it go for option “ c ” or “ d ” above given that sales mix remained constant as provided in each of the two options? Why? What if the guaranteed total sales volume of 7,000 instead of 10,000? Why? What should be the guaranteed total sales volume for the two options to provide equal profit

Gafat Engineering Ethio Plc manufactures two types of TV sets – LCD and CRT – both having only one model. The LCD and CRT television sets sell for Br 9,000 and Br5,000, respectively. The company sells its products through its own stores and other outlets. Total fixed expenses are Br15,000,000 per month. Variable expenses and monthly sales data are given below: LCD CRT Variable expenses Br5,000 Br2,000 Monthly sales in units 2,000 3,000 Required: ( unless stated figures should be computed for one month ) a) Determine breakeven total volume of sales and sales volume for each product. b) Determine sales volume and sales revenue for the company to earn Br500,000 profit after 30% profit tax. c) The company has planned to incur Br 200,000 monthly selling (promotional) expenses to increase sales volume for its LCD TV sets to 4,000. If the plan materializes and other things remain constant, determine breakeven sales volume and sales revenue for the company. d) The company has planned to buy new and improved technology that reduces variable production expenses for its LCD TV set to Br4,000 while increasing its monthly fixed production costs by Br500,000. If the plan materializes and other things remain constant, determine breakeven sales volume and sales revenue for the company. e) If the company is guaranteed with total sales volume of 10,000 TV sets in a given month, should it go for option “ c ” or “ d ” above given that sales mix remained constant as provided in each of the two options? Why? What if the guaranteed total sales volume of 7,000 instead of 10,000? Why? What should be the guaranteed total sales volume for the two options to provide equal profit

Read More

Project Name: Fatigue analysis of wind turbine bearings. A Wind Turbine converts wind’s kinetic energy into electrical power. After hydropower, wind power is the second biggest contributor to Australia’s renewable energy supply. Wind turbines capture wind energy within the area swept by their blades. They produce a power output proportional to the air density and the wind speed cubed. The spinning blades drive an electrical generator that produces electricity for export to the grid. Bearings are one of the most important components of wind turbines and require designs that optimize reliability and economic efficiency while taking into account the characteristics of the applications. Bearings of different types are being used in rotor shaft, gearbox (step-up gear), generator, yaw gearbox (reduction), yaw slewing table, blade pitch revolving seat and hydraulic pump in wind turbine. Slewing ring bearings are typically found in the pitch and yaw locations of a turbine and help ensure that the blades rotate smoothly. Spherical roller bearings are often used in the main shaft of the turbine and various combinations of CRBs, TRBs and ball bearings are used in the gearbox of a wind turbine. A wind turbine can be failed due to Gear box failures, generator failures and main shaft failure and so on. According to current trend 70% of gearbox and 67% of generator of wind turbine being failed due to Bearings. So fatigue analysis of bearings in wind turbine is very important and can play a major role to prevent the turbine failure. Existing literature has shown the importance and fatigue analysis of bearing in wind turbine for preventing the failures and I propose to investigate this area further and look at stress, forces and external loading of the bearings in wind turbine. My project will also perform an analysis of fatigue failure and fatigue life of bearing in wind turbine which will help to prevent mechanical failure because of early bearing fatigue such as excessive stress, loading and vibration. Method importing various bearings in solidwork This stage includes importing wind turbine bearings into solidwork for doing the further analysis. Use of solidwork simulation Here solidwork simulation software is used to analysis the stresses, maximum loading, forces of bearings and some calculation is done to determine fatigue life and fatigue failure of bearings. Collection of data and result Then all the data will be collected from different analysis of bearings and then result of different analysis would be compared with theoretical result. Conclusion Finally we will come up with a best result from the analysis and a conclusion will be made. A detailed report would be made after that for the project. Example Souichi YAGI, Nobuyuki NINOYU, Bearings for Wind Turbine, NTN Global Technical review No.71 (2014). This report introduces a method to optimize wind turbine bearing design and the features of bearings developed for wind turbines. It also cover the study to calculate and analyse the bearing life for the maximum required strength of the housing and the average deformation of the housing. I have also learned how to work with solidwork simulation software with different bearings of wind turbine. By studying this i got the idea of deflection analysis results of different bearing used for wind turbine gearbox. FEA analysis example of wind turbine main bearing Schaeffler Technologies GmbH & Co. KG, Modern simulation and calculation programs, Bearing Solutions and Service for Wind Turbines. This article presents information about most up-to-date simulation and calculation programs in order to ensure the optimum selection of products. I got the knowledge of using hybrid multi-body simulation (MBS) and how the dynamic behaviour of the entire wind turbine is displayed. Based on the model, individual components of the drive train and the entire wind turbine design can be improved as early as the development phase. By using Bearinx software, all bearing types, complex shafts, and shaft systems through to complete drive units can be modeled and calculated. The support reactions, the internal stresses of the bearings, the comparative stress of the shafts, and the most important parameters are calculated and can be displayed graphically or in a table. Comprehensive analysis example of Optimum bearing design of wind turbine MTS wind power solution, Improving Reliability through Mechanical Testing & simulation. http://www.mts.com/cs/groups/public/documents/generaldocuments/dev_004820.pdf viewed on June 2017. MTS solutions are deployed worldwide, subjecting wind turbine materials, components and structures to a full spectrum of mechanical testing, including characterization, strength testing, durability testing and systems testing. This literature describe about mechanical tests on a wide array of wind turbine bearings, including pitch, yaw and main bearing systems. By studying this paper I have learned about different testing procedure of Blade pitch bearing of a wind turbine. Different Wind turbine bearing are performed under load and the simulation and optimum test accuracy achieved with state-of-the-art FlexTest digital controls, Multipurpose TestWare software and RPC Pro software. 1. Emamode A Ubogu, High Reliability and low friction bearings for Wind Turbines, University of Sheffield. Viewed in May 2017. This literature describes the various bearing options available to the different bearing components of a wind turbine, wind turbine architecture and Bearing life calculation of a wind turbine. The basic life calculation formula was used for this project, which involves the steps below-

Project Name:  Fatigue analysis of wind turbine bearings.

A Wind Turbine converts wind’s kinetic energy into electrical power. After hydropower, wind power is the second biggest contributor to Australia’s renewable energy supply. Wind turbines capture wind energy within the area swept by their blades. They produce a power output proportional to the air density and the wind speed cubed. The spinning blades drive an electrical generator that produces electricity for export to the grid.

Bearings are one of the most important components of wind turbines and require designs that optimize reliability and economic efficiency while taking into account the characteristics of the applications. Bearings of different types are being used in rotor shaft, gearbox (step-up gear), generator, yaw gearbox (reduction), yaw slewing table, blade pitch revolving seat and hydraulic pump in wind turbine. Slewing ring bearings are typically found in the pitch and yaw locations of a turbine and help ensure that the blades rotate smoothly. Spherical roller bearings are often used in the main shaft of the turbine and various combinations of CRBs, TRBs and ball bearings are used in the gearbox of a wind turbine.

A wind turbine can be failed due to Gear box failures, generator failures and main shaft failure and so on. According to current trend 70% of gearbox and 67% of generator of wind turbine being failed due to Bearings. So fatigue analysis of bearings in wind turbine is very important and can play a major role to prevent the turbine failure. Existing literature has shown the importance and fatigue analysis of bearing in wind turbine for preventing the failures and I propose to investigate this area further and look at stress, forces and external loading of the bearings in wind turbine. My project will also perform an analysis of fatigue failure and fatigue life of bearing in wind turbine which will help to prevent mechanical failure because of early bearing fatigue such as excessive stress, loading and vibration.

Method

importing various bearings in solidwork

This stage includes importing wind turbine bearings into solidwork for doing the further analysis.

Use of solidwork simulation

Here solidwork simulation software is used to analysis the stresses, maximum loading, forces of bearings and some calculation is done to determine fatigue life and fatigue failure of bearings.

Collection of data and result

Then all the data will be collected from different analysis of bearings and then result of different analysis would be compared with theoretical result.

Conclusion

Finally we will come up with a best result from the analysis and a conclusion will be made. A detailed report would be made after that for the project.

Example

 

Souichi YAGI, Nobuyuki NINOYU, Bearings for Wind Turbine, NTN Global Technical review No.71 (2014).

 

This report introduces a method to optimize wind turbine bearing design and the features of bearings developed for wind turbines. It also cover the study to calculate and analyse the bearing life for the maximum required strength of the housing and the average deformation of the housing.

I have also learned how to work with solidwork simulation software with different bearings of wind turbine. By studying this i got the idea of deflection analysis results of different bearing used for wind turbine gearbox.

 

FEA analysis example of wind turbine main bearing

 

 

 

Schaeffler Technologies GmbH & Co. KG, Modern simulation and calculation programs, Bearing Solutions and Service for Wind Turbines.

 

This article presents information about most up-to-date simulation and calculation programs in order to ensure the optimum selection of products. I got the knowledge of using hybrid multi-body simulation (MBS) and how the dynamic behaviour of the entire wind turbine is displayed. Based on the model, individual components of the drive train and the entire wind turbine design can be improved as early as the development phase.

By using  Bearinx software, all bearing types, complex shafts, and shaft systems through to complete drive units can be modeled and calculated. The support reactions, the internal stresses of the bearings, the comparative stress of the shafts, and the most important parameters are calculated and can be displayed graphically or in a table.

 

Comprehensive analysis example of Optimum bearing design of wind turbine

 

 

 

 

MTS wind power solution, Improving Reliability through Mechanical Testing & simulation.

http://www.mts.com/cs/groups/public/documents/generaldocuments/dev_004820.pdf viewed on June 2017.

 

 

MTS solutions are deployed worldwide, subjecting wind turbine materials, components and structures to a full spectrum of mechanical testing, including characterization, strength testing, durability testing and systems testing. This literature describe about mechanical tests on a wide array of wind turbine bearings, including pitch, yaw and main bearing systems. By studying this paper I have learned about different testing procedure of Blade pitch bearing of a wind turbine. Different Wind turbine bearing are performed under load and the simulation and optimum test accuracy achieved with state-of-the-art FlexTest digital controls, Multipurpose TestWare software and RPC Pro software.

 

 

 

 

 

 

 

  1. Emamode A Ubogu, High Reliability and low friction bearings for Wind Turbines, University of Sheffield. Viewed in May 2017.

 

This literature describes the various bearing options available to the different bearing components of a wind turbine, wind turbine architecture and Bearing life calculation of a wind turbine. The basic life calculation formula was used for this project, which involves the steps below-

 

 

Read More

Work is a part of the daily lives of most people, and in many of the positions we have occupied throughout lives, we have worked under the supervision of a leader or superior. Your text summarizes the research on leadership and management styles and then comments on differences across cultures. We often talk about effective leaders or natural leaders or leaders who usher in change, but regardless of what we call leaders in American culture, we tend to value effective and charismatic leaders that can impart transformative change in our organizations. In fact, theorists have developed a hierarchy of leadership effectiveness that ranges from the highly competent individual who makes productive contributions and had good work habits to the level 5 leader or the Executive who builds organizational greatness through vision, commitment, will and humility. Think back about the leaders or supervisors for whom you have worked. Which leadership and management styles did you experience as most positive and were most effective at encouraging you to be a productive employee? Which leadership styles resulted in the production of negative attitudes or decreased motivation to perform well? ***One reference is required

Work is a part of the daily lives of most people, and in many of the positions we have occupied throughout lives, we have worked under the supervision of a leader or superior. Your text summarizes the research on leadership and management styles and then comments on differences across cultures. We often talk about effective leaders or natural leaders or leaders who usher in change, but regardless of what we call leaders in American culture, we tend to value effective and charismatic leaders that can impart transformative change in our organizations. In fact, theorists have developed a hierarchy of leadership effectiveness that ranges from the highly competent individual who makes productive contributions and had good work habits to the level 5 leader or the Executive who builds organizational greatness through vision, commitment, will and humility.

Think back about the leaders or supervisors for whom you have worked. Which leadership and management styles did you experience as most positive and were most effective at encouraging you to be a productive employee? Which leadership styles resulted in the production of negative attitudes or decreased motivation to perform well? ***One reference is required

Read More

NetLogo Assignment 3 Messaging (10% plus 10% bonus = 20%). Due on 11th October. Close-off 18th October. You should now be familiar with Netlogo and ready to apply your new found knowledge. You are to design a netlogo model of a messaging network (nodes and links) with the idea of seeing how a large file is saved and retrieved on a dispersed distributed network. You can think of the nodes as server components of a distributed network and consider local domains and so on. On this network file chunks pass between servers and are saved on chunk servers. I suggest you use the Google File System as a template for your model. The best way of starting out is to look at the network models in the NetLogo library (there are several suitable candidates). In this model, I want you to include Synchronisation considerations (as per this weeks lecture). For bonus marks add additional features of distributed networks covered in lectures for a maximum 10% additional marks. Bronze Level (70 marks): 1. What do you want to model (you had practice in doing requirements in the previous assignment). 2. Select candidate library models to consider for the basis of your messaging network model. Why did you select them? What effort is required to adapt them? 3. Devise a plan of how to build the model. The objective (subject to your interpretation) is to save a file, break it down in chunks, save it to chunk servers and then reverse the process. 4. How will you cater for modelling synchronisation? what type of synchronisation will you select for modelling and how would you track the synchronisation process? 5. What are your expectations for the model (inputs to change, outputs to monitor)? Silver and Gold Levels (30 marks): 1. Build the model. 2. Document your work. 3. Run the model and document your observations. Gold Level (20 marks): 1. Validate the model (does it work). 2. Document Issues and suggest improvements. 3. Assess the model for usefulness.

NetLogo Assignment 3 Messaging (10% plus 10% bonus = 20%).

Due on 11th October. Close-off 18th October.

You should now be familiar with Netlogo and ready to apply your new found knowledge. You are to design a netlogo model of a messaging network (nodes and links) with the idea of seeing how a large file is saved and retrieved on a dispersed distributed network.

You can think of the nodes as server components of a distributed network and consider local domains and so on. On this network file chunks pass between servers and are saved on chunk servers. I suggest you use the Google File System as a template for your model. The best way of starting out is to look at the network models in the NetLogo library (there are several suitable candidates).

In this model, I want you to include Synchronisation considerations (as per this weeks lecture).  For bonus marks add additional features of distributed networks covered in lectures for a maximum 10% additional marks.

Bronze Level (70 marks):

  1. What do you want to model (you had practice in doing requirements in the previous assignment).
  2. Select candidate library models to consider for the basis of your messaging network model. Why did you select them? What effort is required to adapt them?
  3. Devise a plan of how to build the model. The objective (subject to your interpretation) is to save a file, break it down in chunks, save it to chunk servers and then reverse the process.
  4. How will you cater for modelling synchronisation? what type of synchronisation will you select for modelling and how would you track the synchronisation process?
  5. What are your expectations for the model (inputs to change, outputs to monitor)?

Silver and Gold Levels (30 marks):

  1. Build the model.
  2. Document your work.
  3. Run the model and document your observations.

Gold Level (20 marks):

  1. Validate the model (does it work).
  2. Document Issues and suggest improvements.
  3. Assess the model for usefulness.

 

Read More