Assignment Fall 2016
Module: Digital Communication (ELEC 20004) ID NUMBER
Level: 2 Max. Marks: 100
Session: All
Assignment Outcomes
Differentiate the types of pulse modulation techniques implemented in communication systems;
Critically evaluate the baseband demodulation and detection techniques;
Critically evaluate digital modulation techniques including multi-level digital modulation.
Guidelines:
Please add front title page with your answers uploaded on Moodle.
Each question carries 20 marks.
Assignment answers must be computer typed. Please do not write question statement. Just mention the question number.
Font – Times New Roman
Font – Style – Regular
Font – Size – 12
Soft copy of the assignment is to be submitted online in Moodle through turnitin.
Each student has to do the assignment individually.
Explain with suitable diagrams wherever required.
The final assignment must have a Title Page, table of contents, references/ bibliography and page number.
Heading should be with Font Size 14, Bold, and Underline.
You can refer books in Library or use internet resource. But you should not cut and paste material from internet nor provide photocopied material from books. The assignment answers should be in your own words after understanding the matter from the above resources.
Rules & Regulations
If any coursework assessment is found to be copied from other candidates using unacceptable means, then it shall be cancelled and the total marks awarded will be zero. No chance of resubmission or appeal will be given*.
Your source of information should be mentioned in the reference page clearly. (For example: If it’s from book, you have to mention the full details of the book with title, author name, edition and publisher’s name. If it is from the internet you have to mention the correct URL). Otherwise the assignment will be considered as plagiarized*.
The students may be asked to appear for a viva voce to validate the assignment solutions submitted. The viva voce does not carry any marks.
Title Page must have Assignment Name, Module name, your name, ID, Section and the name of the faculty.
For late submission, 5% of the awarded marks will be deducted for each working day.
For plagiarism, please refer to student guide and clarification uploaded on Moodle.
Refer MIG for feedback dates on assignment.
No assignment will be accepted after one week from the date of submission*.
Date of submission 27/12/2016
* Refer to the MIG for MEC policy on academic integrity and late submission.
A waveform that is band limited to 50 k Hz is sampled every 10µs. Show graphically that these samples uniquely characterize the waveform. (Use a sinusoidal example. Avoid sampling at points where the waveform equals zero.) (6 Marks)
If the samples are taken 30µs apart instead of 10µs,show graphically that the waveforms other than the original can be characterized by the samples.
(6 Marks)
A Sinusoidal voice signal s(t)=cos?(6000pt) is to be transmitted using either PCM or DM. The sampling rate for PCM is 8kHz and for the transmission with DM,the step size ? is decided to be of 31.25mV.The slope overload distortion is to be avoided.Assume that the number of quantization levels for a PCM system is 64. Determine the signaling rates of the both the systems and also comment on the result. (8 Marks)
A compact disc(CD) records audio signals digitally by using PCM. Assume that the audio signal bandwidth equals 15kHz.
If the Nyquist sample are uniformly quantized into L=65,536 levels and then binary-coded, determine the number of binary digits required to encode a sample.
If the audio signal has average power of 0.1 W and peak voltage of 1 V. Find the resulting ratio of signal to quantization noise (SQNR) of the uniform quantizer output in part (i).
Determine the number of binary digits per second (bit/s) required to encode the audio signal and minimum bandwidth required to transmit the encoded signal.
Practically signals are sample well above the Nyquist rate. Practical CDs use 44100 samples per second.If L=65536,determine the number of bits per second required to encode the signal,and the minimum bandwidth required to transmit the encoded signal. (10 Marks)
Given an analog waveform that has been sampled at its Nyquist rate, fs using natural sampling, prove that a waveform (proportional to the original waveform) can be recovered from the samples, using recovery technique shown in figure 2. The parameter mfs, is the frequency of local oscillator, where m is an integer.
(10 Marks)
(Hint: ? x?_p (t)=?_(n=-8)^8¦C_n e^(j2pnf_s t) x_s (t)=x(t).x_p (t)))
Consider the signals shown below Figure 1.
Figure 1
Each of the signals shown in Figure 1 can be written using the form Asin(2p ft +f). For each signal, determine the values of A,f and f.
Consider a composite signal which contains each of the four signals shown in Figure 1 added together. Show the combined signals amplitude versus frequency-domain plot. What is the equation for this combined signal? What is the bandwidth of this signal?
If the composite signal from part (ii) was passed through a special filter that removes its DC component, what would be the bandwidth of the filtered signal?
(12 Marks)
Coherent detectors are used to detect FSK signal with a rate of 2Mbps. Assuming AWGN channel with the noise power spectral density No/2 = 10-20W/Hz. Determine the probability error. Assume the amplitude of the received signal is 1µV. (8 Marks)
Imagine you wish to transmit the last four digits of your ID no. First you will need to convert your student ID from its decimal (base 10) representation into a 28-bit binary (base 2) representation. Using clearly labeled diagrams, show an encoding of your ID using:
[14 Marks]
NRZ-L signal,
NRZ-AMI
Bi-Ø-L
Delay Modulation
(Note that ASCII Conversion sheet provided to you)
A binary communication system transmits signals si(t) (i=1,2).The receiver test statistic z(T)=ai+n0 ,where the signal component ai is either a1=+1 or a2=-1 and the noise component n0 is uniformly distributed, yielding the conditional density functions given by
and
Find the probability of a bit error, PB for the case of equally likely signaling and the use of an optimum decision threshold. (6 Marks)
Show that for a bit stream b(t) =011011100001, the MSK waveform has phase continuity with the help of suitable mathematical analysis and waveforms. (20 Marks)
Assume that m=5 for f_H=(m+1) f_b/4
f_L=(m-1) f_b/4

Assignment Fall 2016
Module: Digital Communication (ELEC 20004) ID NUMBER
Level: 2 Max. Marks: 100
Session: All
Assignment Outcomes
Differentiate the types of pulse modulation techniques implemented in communication systems;
Critically evaluate the baseband demodulation and detection techniques;
Critically evaluate digital modulation techniques including multi-level digital modulation.
Guidelines:
Please add front title page with your answers uploaded on Moodle.
Each question carries 20 marks.
Assignment answers must be computer typed. Please do not write question statement. Just mention the question number.
Font – Times New Roman
Font – Style – Regular
Font – Size – 12
Soft copy of the assignment is to be submitted online in Moodle through turnitin.
Each student has to do the assignment individually.
Explain with suitable diagrams wherever required.
The final assignment must have a Title Page, table of contents, references/ bibliography and page number.
Heading should be with Font Size 14, Bold, and Underline.
You can refer books in Library or use internet resource. But you should not cut and paste material from internet nor provide photocopied material from books. The assignment answers should be in your own words after understanding the matter from the above resources.
Rules & Regulations
If any coursework assessment is found to be copied from other candidates using unacceptable means, then it shall be cancelled and the total marks awarded will be zero. No chance of resubmission or appeal will be given*.
Your source of information should be mentioned in the reference page clearly. (For example: If it’s from book, you have to mention the full details of the book with title, author name, edition and publisher’s name. If it is from the internet you have to mention the correct URL). Otherwise the assignment will be considered as plagiarized*.
The students may be asked to appear for a viva voce to validate the assignment solutions submitted. The viva voce does not carry any marks.
Title Page must have Assignment Name, Module name, your name, ID, Section and the name of the faculty.
For late submission, 5% of the awarded marks will be deducted for each working day.
For plagiarism, please refer to student guide and clarification uploaded on Moodle.
Refer MIG for feedback dates on assignment.
No assignment will be accepted after one week from the date of submission*.
Date of submission 27/12/2016
* Refer to the MIG for MEC policy on academic integrity and late submission.

A waveform that is band limited to 50 k Hz is sampled every 10µs. Show graphically that these samples uniquely characterize the waveform. (Use a sinusoidal example. Avoid sampling at points where the waveform equals zero.) (6 Marks)

If the samples are taken 30µs apart instead of 10µs,show graphically that the waveforms other than the original can be characterized by the samples.
(6 Marks)
A Sinusoidal voice signal s(t)=cos?(6000pt) is to be transmitted using either PCM or DM. The sampling rate for PCM is 8kHz and for the transmission with DM,the step size ? is decided to be of 31.25mV.The slope overload distortion is to be avoided.Assume that the number of quantization levels for a PCM system is 64. Determine the signaling rates of the both the systems and also comment on the result. (8 Marks)

A compact disc(CD) records audio signals digitally by using PCM. Assume that the audio signal bandwidth equals 15kHz.
If the Nyquist sample are uniformly quantized into L=65,536 levels and then binary-coded, determine the number of binary digits required to encode a sample.
If the audio signal has average power of 0.1 W and peak voltage of 1 V. Find the resulting ratio of signal to quantization noise (SQNR) of the uniform quantizer output in part (i).
Determine the number of binary digits per second (bit/s) required to encode the audio signal and minimum bandwidth required to transmit the encoded signal.
Practically signals are sample well above the Nyquist rate. Practical CDs use 44100 samples per second.If L=65536,determine the number of bits per second required to encode the signal,and the minimum bandwidth required to transmit the encoded signal. (10 Marks)
Given an analog waveform that has been sampled at its Nyquist rate, fs using natural sampling, prove that a waveform (proportional to the original waveform) can be recovered from the samples, using recovery technique shown in figure 2. The parameter mfs, is the frequency of local oscillator, where m is an integer.
(10 Marks)

(Hint: ? x?_p (t)=?_(n=-8)^8¦C_n e^(j2pnf_s t) x_s (t)=x(t).x_p (t)))

Consider the signals shown below Figure 1.

Figure 1
Each of the signals shown in Figure 1 can be written using the form Asin(2p ft +f). For each signal, determine the values of A,f and f.
Consider a composite signal which contains each of the four signals shown in Figure 1 added together. Show the combined signals amplitude versus frequency-domain plot. What is the equation for this combined signal? What is the bandwidth of this signal?
If the composite signal from part (ii) was passed through a special filter that removes its DC component, what would be the bandwidth of the filtered signal?
(12 Marks)
Coherent detectors are used to detect FSK signal with a rate of 2Mbps. Assuming AWGN channel with the noise power spectral density No/2 = 10-20W/Hz. Determine the probability error. Assume the amplitude of the received signal is 1µV. (8 Marks)
Imagine you wish to transmit the last four digits of your ID no(12f9612). First you will need to convert your student ID from its decimal (base 10) representation into a 28-bit binary (base 2) representation. Using clearly labeled diagrams, show an encoding of your ID using:
[14 Marks]
NRZ-L signal,
NRZ-AMI
Bi-Ø-L
Delay Modulation
(Note that ASCII Conversion sheet provided to you)
A binary communication system transmits signals si(t) (i=1,2).The receiver test statistic z(T)=ai+n0 ,where the signal component ai is either a1=+1 or a2=-1 and the noise component n0 is uniformly distributed, yielding the conditional density functions given by

and
Find the probability of a bit error, PB for the case of equally likely signaling and the use of an optimum decision threshold. (6 Marks)
Show that for a bit stream b(t) =011011100001, the MSK waveform has phase continuity with the help of suitable mathematical analysis and waveforms. (20 Marks)
Assume that m=5 for f_H=(m+1) f_b/4
f_L=(m-1) f_b/4

100% Original work. APA format Select a television program that you know contains a social inequality or social class theme (e.g. racism, sexism, social class categories). Select one of the following options to deliver your assignment: Write a 700- to 1,050-word analysis. Format your assignment according to appropriate course level APA guidelines.

•Summarize the criminal justice policy by explaining how the policy affects the basic premises of the criminal justice system, its organization, and its structure. •Complete a literature review for the policy incorporating your two journal article reviews. •Analyze the criminal justice policy process including the relationships between the federal, state, and local stakeholders who influence criminal justice policy. •Address the constitutional issues that should be addressed by policy makers or the U.S. Supreme Court. •Revise existing public policy to address specific criminal justice issues. •Explain the effects of public policy on internal criminal justice operations. •Analyze the effect of criminal justice policy on social justice •Be a minimum of eight double-spaced pages in length (excluding title and references pages) and formatted according to APA style •Include a title page with the following: ◦Title of paper ◦Student’s name ◦Course name and number ◦Instructor’s name ◦Date submitted •Address the topic of the paper with critical thought. •Utilize a minimum of 10 scholarly and/or peer-reviewed source •Include a separate references page, formatted according to APA style

For this week’s assignment, you will examine the global criminal perspective of two types of transnational crimes. Chapter 2 in the text discusses domestic crime, transnational crime, and justice. Find additional credible sources to assist in your evaluation of international policing and investigative agencies’ attempts to locate and arrest individuals that are engaged in these transnational crimes. Before you begin writing your paper, choose two types of transnational crime from the list below: • Cybercrime • Drug trafficking • Human trafficking • Money laundering • Maritime piracy • Theft of art and cultural objects • Trade in human body parts • Terrorism In your paper, relative to the chosen two types of transnational crime • Describe what international policing and investigative agencies are doing well. • Identify areas in need of improvements. • Discuss what we as individuals can do to help with transnational crime rates. • Identify some warning signs that these transnational crimes may be taking place around us. • Evaluate what the United States has done to improve transnational crime rates. • Identify which national agencies are involved in the United States’ attempt to manage transnational crime. • Discuss each agency’s role in these efforts. The paper • Must be at least four double-spaced pages in • Must use at least two credible sources in addition to the course text.

please let me know I will add the instructions the paper is attached Prepare a 4–5-page report in which you identify three functional areas you believe are essential for organizational success. Explain the purpose of each functional area and how the purpose supports organizational goals. In addition, describe the organizational structure best suited for the functional areas, and explain how the functional areas support continued organizational success.

The functional areas within a business or organization contribute to the smooth and effective running of the business. Although the number and names of the functional areas vary from organization to organization, there are five that are key in almost every organization: Human Resources, Accounting and Finance, Sales and Marketing, Production and Operations, and Information Technology (IT) Systems.

SHOW LESS By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

Explain the underlying principles of successful business. Explain the primary purpose of the essential functional areas of an organization. Explain how the purpose of the essential functional areas supports organizational goals. Describe the relationship between organizational structure and its essential functional areas. Explain how the essential functional areas promote continued organizational success. Communicate in a manner that is scholarly, professional, and consistent with expectations for the field of business. Write coherently using correct grammar, usage, and mechanics. Use evidence to support a central idea in a consistently appropriate APA format.

*new*

Prepare a 4–5-page report in which you identify three functional areas you believe are essential for organizational success. Explain the purpose of each functional area and how the purpose supports organizational goals. In addition, describe the organizational structure best suited for the functional areas, and explain how the functional areas support continued organizational success.

The functional areas within a business or organization contribute to the smooth and effective running of the business. Although the number and names of the functional areas vary from organization to organization, there are five that are key in almost every organization: Human Resources, Accounting and Finance, Sales and Marketing, Production and Operations, and Information Technology (IT) Systems.

SHOW LESS By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

Competency 1: Explain the underlying principles of successful business. Explain the primary purpose of the essential functional areas of an organization. Explain how the purpose of the essential functional areas supports organizational goals. Describe the relationship between organizational structure and its essential functional areas. Explain how the essential functional areas promote continued organizational success. Competency 5: Communicate in a manner that is scholarly, professional, and consistent with expectations for the field of business. Write coherently using correct grammar, usage, and mechanics. Use evidence to support a central idea in a consistently appropriate APA format.

Assessment Value: 20%
Instructions:
• This assignment is to be submitted in accordance with assessment policy stated in the Subject Outline and Student Handbook.
• It is the responsibility of the student who is submitting the work, to ensure that the work is in fact her/his own work. Incorporating another’s work or ideas into one’s own work without appropriate acknowledgement is an academic offence. Students should submit all assignments for plagiarism checking on Blackboard before final submission in the subject. For further details, please refer to the Subject Outline and Student Handbook.
• Answer all questions.
• Maximum marks available: 20 marks.
• Due date of submission: Week 10.
Question 1 (10 Marks)
Two years ago Peta purchased a house in Kew. This house had two old tennis courts down the back which were in poor condition. She purchased the property for two reasons:
• so that she and her family could live in the house; and
• so that she could build three units on the tennis courts and sell them at a profit.
In the current tax year the tennis club next door offered to buy the old tennis courts, but only if Peta first restored them to good condition. Peta decided to accept the club’s offer instead of going ahead with her plan to build and sell units.
Peta spent $100,000 on preparing the tennis courts for sale. This involved a great deal of work. Peta had to resurface the tennis courts and build new fences around them. She then sold the tennis courts in the current tax year to the tennis club for $600,000.
Ignoring capital gains tax, discuss whether the receipt of $600,000 is ordinary income under s 6-5.
Question 2 (10 marks)
Alan is an employee at ABC Pty Ltd (ABC). He has negotiated the following remuneration package with ABC:
• salary of $300,000;
• Payment of Alan’s mobile phone bill ($220 per month, including GST). Alan is under a two-year contract whereby he is required to pay a fixed sum each month for unlimited usage of his phone. Alan uses the phone for work-related purposes only;
• Payment of Alan’s children’s school fees ($20,000 per year). The school fees are GST free.
ABC also provided Alan with the latest mobile phone handset, which cost $2,000 (including GST).
At the end of the year ABC hosted a dinner at a local Thai restaurant for all 20 employees and their partners. The total cost of the dinner was $6,600 including GST.
(a) Advise ABC of its FBT consequences arising out of the above information, including calculation of any FBT liability, for the year ending 31 March 2016. Assume that ABC would be entitled to input tax credits in relation to any GST-inclusive acquisitions.
(b) How would your answer to (a) differ if ABC only had 5 employees?
(c) How would your answer to (a) differ if clients of ABC also attended the end-of-year dinner?

Assignment 2
Overview
For this assignment you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create the database structures, to fill the database with data and to run queries on the data.
Timelines and Expectations
Percentage Value of Task: 20%
Due: Friday Week 11 (5:00 pm)
Minimum time expectation: 20 hours
Learning Outcomes Assessed
The following course learning outcomes are assessed by completing this assessment:
• A1.design and implement a relational database using a database management system
• A2.utilise a query language tools and techniques to obtain data and information from a database
• K5. describe relational algebra and its relationship to Structured Query Language (SQL)
• S1.interpret entity-relationship diagrams to implement a relational database
• S2.demonstrate skills in designing and building a database application using a commercially available database management system development tool
• S3.use a query language for data manipulation
Assessment Details
FHTS Incorporated has provided you with a standard solution for the conceptual data model (the ER diagram). You have been commissioned to continue your role (in your capacity as a Database Management System consultant) and to write the SQL statements to create the database and its tables, add data, and to provide SQL solutions to some of their everyday queries. The database should be created based on the ER diagram provided at the end of this document. Some sample data are also provided to be used for inserting data into tables. However, you are also required to insert sufficient data to test the reports given below.
To implement the database
1. Translate the ER diagram provided into a relational schema using the correct notations and standards for this course. It should include:
a. Table names
b. Attribute names and field types (as required by XAMPP)
c. Primary and foreign keys identified
2. Create a text file called nnnnnnnn-create.sql (where nnnnnnnn is your student number). The file should include:
a. The SQL statements to create a database called FHTSnnnnnnnn (where nnnnnnnn is your student ID – e.g. FHTS30011111)
b. The SQL statements to create the tables, including their primary keys, foreign keys and the relationships of the tables.
3. Create a text file called nnnnnnnn_insert.sql (where nnnnnnnn is your student number). The file should include:
a. The SQL statements to load sufficient data into each table you have created to test the queries given below. Sample data has been provided, but you will need to include further data to test the requirements. You should add at least one record to the existing test data for each table.
b. You are required to include your name as one of the customers, (you can provide fake address details), but you MUST have your name and give your student id as the phone number.
4. Create a text file called nnnnnnnn_query.sql (where nnnnnnnn is your student number). The file should include the SQL statements necessary to display the following reports:
a. List all details of all the records in the customer table, sorted by their Last name in descending order.
b. List all the customers by their first name and last name in one column, (ensuring a space between the names), with an appropriate title, followed by their phone number and then followed by the name and phone number of the company they work for. Sort this list by the company name in ascending order.
c. List the first name, last name and email address of all customers.who are either/or both VIP or Frequent Flyers. (hint, check the fields with “yes” or “no”), Also list the CustVIP and CustFreqFlyer fields, changing their titles to “VIP” and “Frequent Flyer” respectively.
d. List all of the VIP customers, with their first name and last name joined in the title, as “VIP Customer”, followed by their years as a customer, and the money they have spent as a customer of FHTS. Hint, look at the sub type.
e. List all frequent flyer customers who have made a booking, giving their first and last names, the number of frequent flyer points they have, followed by their frequent flyer rate points, then followed by a column that gives their frequent flyer discount. i.e for each frequent flyer customer on a booking perform the multiplication between their frequent flyer points and their respective frequent flyer rate per points, which is found in the FREQ_FLYER_DISCOUNT table. (This query will entail a number of joins). Also give the last column an appropriate name. Don’t worry about duplicates found from the query, this is due to multiple bookings.
f. List the staffId, first name and last name of all staff members who are supervisors, also including the ID and last name of each staff member who reports to them.
g. Delete the customer Tim Canterbury.
h. Change customer Rachael Bernard name to Rachael Jones.
i. List all bookings that have flights to the United States. Include the Booking ID, Customer ID, FlightID, Flight Number, booking date and flight booking date,in the output. (Can you see any errors in the data for the bookings?)
j. List all the bookings that don’t contain flights to the United States. This time just list the Booking ID and Customer ID. Use the previous query as a sub-query here.
k. Insert a new flight for Air France with the flight number “AF513”. It will depart from the Melbourne airport with a destination to London Heathrow airport. Its departure date is set for 29th September 2016 and its arrival is set for the next day, 30th September 2016. It has a large flight capacity 520 passengers. The fixed flight fee will be $180. The distance is approximately 16,927 km.
l. List all accommodation details for sites connected to locations with airports that have the last word “International” in its name.
Your documentation should include:
1. A title page clearly stating your name and student ID and your tutor’s name.
2. A copy of the relational schema you have developed from the ER diagram provided.
3. A copy of the three files you are required to create included in the document (ie nnnnnnnn_create.sql, nnnnnnnn_insert.sql and nnnnnnnn_query.sql).
4. Full APA referencing of any resources you have used to complete your submission
You should submit the following:
1. The documentation file described above EITHER as a MS word file or a PDF. If you are using a mac, please submit in a PDF so I can be sure of opening it.
2. The nnnnnnnn_create.sql file (where nnnnnnnn is your student number).
3. The nnnnnnnn_insert.sql file (where nnnnnnnn is your student number).
4. The nnnnnnnn_query.sql file (where nnnnnnnn is your student number).
Please note that the SQL files must be either .txt or .sql because I will be running them. If they are in a word or pdf file there will be extra characters that will prevent the files from running without errors and THIS WILL COST YOU MARKS!
The assignment is to be submitted via the Assignment 2 submission box in Moodle. This can be found in the Assessments section of the course Moodle shell.
ER Diagram

Sample Data for Tables.
COMPANY
CompName CompPhone CompFax CompEmail
A touch of Glass 0890154261 0890154255 contact@touchofclass.com.au
Global Financial services Inc 0240715034 0240715188 info@gfsinc.com
All Database solution services 0353593240 contact@adbss.com.net
Roberts relocation services 0353996294 0353996296 jack@robsrelocservices.com.au
Ozzie trading emporium 0745392471 service@ozziestrading.com
The free trader 0740024701 740024702 contact@trade4u.com
First Choice Furniture 0362629569 0362629578 help@FCFtrading.com
Multi-Systems Merchant Services 0882397333 0882397423 contact@multi-sys.com.au

VIP_DISCOUNT
VIPStatus VIPMinYearsCust VIPMinMoneySpent VIPDiscount
Gold 15 50000 0.2
Silver 10 10000 0.1
Bronze 5 5000 0.05
FREQ_FLYER_DISCOUNT
FreqFlyerStatusDate FreqFlyPointsPerKilometers FreqFlyRatePerPoints
30-June-2012 2.25 0.25
30-June-2013 2.5 0.5
30-June-2014 2.75 0.75
FLIGHT_BOOKING
BookingID FlightID FlightBookingDate NumDaysStay ClassFareType
1 1 01-February-2013 7 Economy
1 2 03-February-2013 3 Business
2 1 30-October-2013 4 Business
3 1 04-January-2014 2 Economy
3 2 05-January-2014 7 First
3 3 06-January-2014 1 Business
CLASS_FARE
ID ClassFareType ClassFarePrice
1 First 15000
1 Business 9000
1 Economy 3000
2 First 11000
2 Business 6500
2 Economy 2200
3 First 13500
3 Business 7500
3 Economy 2900
FLIGHT
Flight Number Flight Depart Location Flight DepLocDate Flight Dest Location Flight DestLocDate Flight Capacity Flight FeeCharge Flight NumKilometers Airline
AA123 11 2013-02-25 1 2013-02-26 367 100 14,935 3
SC456 12 2013-11-15 2 2013-11-16 80 100 9,113 2
AF678 13 2014-01-14 9 2014-01-15 500 100 14,257 1
LOCATION
LocationAirport LocationCountry NumOf LocAccom
Hartsfield Jackson Atlanta International United States 2
Beijing Capital International China 3
Dubai International United Arab Emirates 2
Chicago O’Hare International United States 3
Tokyo International Japan 2
London Heathrow United Kingdom 4
Los Angeles International United States 5
Hong Kong International Kai Tak Hong Kong 3
Charles de Gaulle International France 2
Dallas Fort Worth International United States 1
Sydney Airport Australia 0
Melbourne Airport Australia 0
Perth Airport Australia 0
ACCOMMODATION
AccomName AccomAddress Accom City Accom PostCode Accom Phone Accom Vacancy Location
Renaissance Concourse Atlanta Airport Hotel 1 Hartsfield Center Pkwy Atlanta 30354 1042099999
60 1
Super 8 College Park/Atlanta Airport 2010 Sullivan Rd, College Park Atlanta 30337 7709918985
20 1
Capital Airport Hotel Airport Road Beijing 100621 56 2
Park Inn by Radisson London Heatrow Bath Road Heathrow UB7 0DU 18 6
Campanile Roissy Zone D Activites Du Parc De Roissy Allee Des Vergers Roissy-en-France 95700 4 9
AIRLINE
AirlineName AirlinePhone AirlineEmail
Air France 1300390190
booking@airfrance.com
China Southern Airlines 0011864008695539 booking@csair.com
American Airways 0291011948
contact@aa.com
Marking Criteria/Rubric
Assessment Criteria and Marking Overview Tasks Marks
1. Presentation
• Cover page indicating student name and number and tutor name.
• Page numbers included in report
• Index giving page numbers of various sections
• Overall presentation of the report
• Full APA referencing of all materials used and full disclosure of assistance from all sources including tutors and other students. 5
2 Revised Schema
• Any assumptions explained
• All tables included
• Data types correct
• Primary and foreign keys indicated and referenced correctly 10
3. Create Statements
• File runs with no error messages
• Database created correctly
• All tables created correctly
• All primary and foreign keys created correctly
• Any deletion anomalies corrected 10
4. Insert Statements
• File runs with no error messages
• Default data is inserted correctly
• Additional data for testing is inserted
• Student’s name and number are included in customer file 10
5. SQL statements Total 65 Marks
Q a
• Correct syntax
• Correct table used
• Correct use of sorting statement 3
Q b
• Correct syntax
• Correct tables used
• Where statement correctly formulated and correct using of sorting statements 4
Q c
• Correct syntax
• Correct tables used
• Where statement correctly formulated 4
Q d
• Correct syntax
• Correct table used
• Where statement correctly formulated
• Correct indication of desired values 4
Q e
• Correct syntax and fields used
• Correct tables used
• Correct derived field and calculations
• Where statement correctly formulated
8
Q f
• Correct syntax
• Correct table used
• Correct use of the primary and foreign keys connections
• Correct answer given in the correct order 6
Q g
• Correct syntax
• Correct table used
• Correct result for deletion 5
Q h
• Correct syntax
• Correct table used
• Correct result for update 6
Q i
• Correct syntax
• Correct tables used
• Where statement correctly formulated
• Output formatted correctly 6
Q j
• Correct syntax
• Correct use of the sub-query
• Where statement correctly formulated
• Output formatted correctly 6
Q k
• Correct syntax
• Correct table used
• Inserts done in correct order with correct results 7
Q l
• Correct syntax
• Correct tables used
• Correct use of the wild card string and comparison
• Output formatted correctly 6
Total 100
Feedback
Feedback will be provided via the marked rubric with comments handed out in the tutorial 2 weeks after the submission date. The marks will also be available on FDL Marks at this time.
Plagiarism:
Plagiarism is the presentation of the expressed thought or work of another person as though it is one’s own without properly acknowledging that person. You must not allow other students to copy your work and must take care to safeguard against this happening. More information about the plagiarism policy and procedure for the university can be found at http://federation.edu.au/students/learning-and-study/online-help-with/plagiarism.

HA1022 Principals of Financial Markets Group Assignment
Student should choose firstly an industry and secondly two (2) ASX listed companies in this same industry upon which to undertake a fundamental analysis. Fundamental Analysis seeks to identify factors that are likely to influence directional changes in the value of a company and hence its share price. These factors may be macro or micro in context.
Requirements. The assignment comprises two related sections:
a) Conduct a Top Down analysis of the overall economic environment and consider how forecast changes in economic fundamentals will impact on the performances of companies in the industry your group has chosen. Consider questions including, but not limited to: What is the current interest rate? What is the current value of the $AUD? What is current GDP etc?
b) Conduct a Bottom Up analysis of companies’ current financial situation. Consider accounting ratios and measures of a firm’s performance, how these need to be compared to the industry and company history,
? All of the required information for calculation and often the actual ratio/number can be found on various websites on the internet.
? http://www.investsmart.com.au/
Note: When you are performing the fundamental analysis take a less is more approach. Select a few key performance measures then define each measure; explain what the measure is supposed to show and then what it is showing for the industry/your companies.
Refer to both your textbook and information available on the internet. This assignment involves research to finding the information and then analysing this resulting information.
When writing the report, imagine that your audience are people that know nothing about finance or the financial markets. At each stage you will need to carefully explain what do are analysing and why. Do not think that just because your lecturer will know what this ratio means that you do not have to define it.
You should also give a brief introduction of the industry and the history, mission statement of your chosen companies. Your paper should conclude with a summary of your findings and recommendations for each of your companies. Word length is 2500 (+ 10% is fine too).
Please refer to the marking guide below for the structure of your paper.
1. Executive summary 2 marks
2. Introduction 3 marks
3. Top-down analysis 5 marks
4. Bottom-up analysis 5 marks
5. Summary and recommendations 3 marks
6. Referencing 2 marks
Total 20 marks