Python Assignment – IT Assignment Help

Python Assignment – IT Assignment Help
Assignment Task



MNIST number dataset a set of 70,000 small images of digits handwritten by high school students and employees of the US Cen? sus Bureau. Each image is labeled with the digit it represents. This set has been studied so much that it is often called the “hello world” of Machine Learning: whenever people come up with a new classification algorithm they are curious to see how it will perform on MNIST, and anyone who learns Machine Learning tackles this dataset sooner or later.

Instructions to explore this dataset are:

1. Use Jupyter Notebook for interactive practice of Python and related Machine Learning packages. 5%?

a. For installing jupyter notebook, could install anaconda first, as Anaconda is the most widely used Python distribution for data science and comes pre-loaded with all the most popular libraries and tools.

b. Create virtual environment for each python project

c. For installing libraries

d. For creating a Jupyter notebook. (note always use kernel 3.X ) e. Familiarize yourself with cells in jupyter notebook and practice mixing texts and python coding.

2. Always refer to textbook ‘hands-on machine learning with Scikit-Learn, Keras & TensorFlow‘ for coding help.

3. Specific tasks include

a. download dataset?

b. explore the dataset and output information include? 

i. how many images

ii. how many features and the range of feature values (e.g., histogram of the data value)

iii. how many categories/labels (discrete or continuous type)

iv. visualize randomly selected samples within each category (feel the variance of the data)

v. visualize more data samples to see whether there are bad data samples need to be removed.

c. do more data manipulation?

i. Use two dimensional reduction algorithms, PCA and t-SNE, to reduce the MNIST dataset down to two dimensions and plot each result using Matplotlib. You can use a scatterplot using 10 different colours to represent each image’s target class.

ii. Load the MNIST dataset and split it into a training set and a test set (take the first 60,000 instances for training, and the remaining 10,000 for testing). Train a Random Forest classifier on the dataset and time how long it takes, then evaluate the resulting model on the test set.

iii. Next, use PCA to reduce the dataset’s dimensionality to 174. Train a new Random Forest classifier on the reduced dataset and see how long it takes. Was training much faster? Next, evaluate the classifier on the test set. How does it compare to the previous classifier?.

iv. Summary/conclude your discovery and insights. 3 Structure Prepare a jupyter notebook for this assignment. The structure of the Jupyter notebook should alternate texts and python codes and cover topics listed the in specific tas2.



Design Report for Number Filtering Program with GUI


This assessment task covers Week 1-10 learning material. Multiple attempts of submission are allowed until the due date.

First, understand the various functionalities of a number filtering program from, including filtering integers, fractions, even and odd numbers, multiples and divisors, and number delimiter and sorting.

Then, write about 1000 words design report highlighting how JavaFX architecture can be used to develop a GUI for a Fibonacci number sequence-filtering program. You can learn more about the Fibonacci number sequence from The report should include architectural diagrams in UML for components of the program (e.g., function and GUI classes) and statements explaining them while reflecting JavaFX concepts. Where necessary code or algorithm snippets should be also included in the report and these would be useful for the application development task in your final assessment. This assessment is to assess students’ ability to apply their knowledge and application skills for designing and developing a useful tool application.Structure

Refer to the rubric at the end for details of mark distribution.


Context BestHome specialises in property management company, taking an intermediate role between owners who wish to rent out their furnished property and clients of BestHome who require to rent furnished property for a fixed period. BestHome currently has about 2000 staff working in 100 branches.

Data Requirements:


BestHome has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manges the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market.


Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address, position, salary, name of Supervisor (where applicable), and the details of the branch office at which a member of staff is currently working. The staff number is unique across all branches of BestHome.

Properties for rent

Each branch office offers a range of properties for rent. The data stored for each property includes property number, address (street, city, postcode), type, number of rooms, monthly rent, and the details of the property owner. The property number is unique across all branch offices. The management of a property is assigned to a member of staff whenever it is rented out or requires to be rented out. A member of staff may manage a maximum of 100 properties for rent at any one time.

Property owners

The details of property owners are also stored. There are two main types of property owner: private owners and business owners. The data stored for private owners includes owner number, name, address, telephone number, email, and password. The data stored on business owners includes name of business, type of business, address, telephone number, email, password, and contact name. The password will allow owners access to parts of the BestHome database using the Web.


BestHome refers to members of the public interested in renting property as clients. To become a client, a person must first register at a branch office of BestHome. The data stored on clients includes client number, name, telephone number, email, preferred type of accommodation, and the maximum rent that the client is prepared to pay. Also stored is the name of the member of staff who processed the registration, the date the client joined, and some details on the branch office at which the client registered. The client number is unique across all BestHome branches.


When a property is rented out, a lease is drawn up between the client and the property. The data listed in detail on the lease includes lease number, client number, name and address, property number and address, monthly rent, method of payment, an indication of whether the deposit has been paid deposit (calculated as twice the monthly rent), duration of lease, and the start and end dates of the lease period.

The relational schema for part of the BestHome case study is:

Branch (branchNo, street, city, postcode) Staff (staffNo, fName,

IName, position, sex, DOB, salary, branchNo) PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo) Client (clientNo, fName, IName, telNo, prefType, maxRent, eMail) PrivateOwner (ownerNo, fName, IName, address, telNo, eMail, password) 3 Viewing(clientNo, propertyNo, viewDate, comment) Registration (clientNo, branchNo, staffNo, dateJoined)


1. Draw an Entity Relationship Diagram for the BestHome database based on the descriptions provided above.

2. The relational schema provided above is incomplete. Add the missing entities, attributes and relationships based onthe description of data requirements.

3. Using Azure Data Studio Create a blank MS SQL database. Use your surname as the database name.

4. Write SQL queries to create the BestHome rental database tables and relationships

5. Write SQL queries to insert the data shown in the above figures.

6. Write a query to insert your personal details to the staff database (as a new staff). 4

7. Write SQL queries to provide following information:

a) Identify the total number of staff and the sum of their salaries.

b) Identify the total number of staff in each position at branches in Glasgow.

c) List the name of each Manager at each branch, ordered by branch address. d) List the property number, address, type, and rent of all properties in Glasgow, ordered by rental amount.

e) List the details of properties provided by business owners at a given branch. f) Identify the total number of properties of each type at all branches.

g) Identify the details of private property owners that provide more than one

h) property for rent.

i) Identify flats with at least three rooms and with a monthly rent no higher than £400 in Aberdeen.

j) Identify the properties that have been advertised more than the average number of times.

k) List the details of leases due to expire next month at a given branch.

8. Create Stored Functions to:

l) Identify the total number of properties assigned to each member of staff at a given branch (input: branch code) m) List the number, name, and telephone number of clients and their property preferences at a given branch (input: branch code)

9. Create a stored procedure that increases the salary of employees by 10%. Use transaction management features of SQL (COMMIT, ROLLBACK).

10. Produce a report for the Director of the company outlining the ethical issues that need to be considered and make any recommendations that you think are appropriate. Also, list the potential security threats that could occur and propose countermeasures to overcome them ( 400-500 words).

11. Record a presentation: o Use Zoom to record a short video presentation (3-4 minutes). In your presentation turn on your webcam (to include your face in the presentation) and share your screen (to show your SQL code in Azure Data Studio. Run all queries you’ve written for questions 7 ,8 and 9 in order. Also, explain the commands/functions used for question 8 and 9 and how the query works). Important Notice: The purpose of this recording is to safeguard academic integrity. The assignment will receive a FAIL grade if you do not submit the recorded presentation, or your presentation does not provide adequate evidence that the submitted materials are original and the result of your own work.

This IT Assignment has been solved by our IT experts at Schooling Best. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.