All posts by : chebby

Each answer 150 words with 1 APA 7 reference

 Exp19_Access_Ch03_ML1 – Small Business Loans 1.0

 “Hands-On” Exercises 

1. Write the HTML to display your name with the largest heading element. Provide Screenshot for output.
2. Think of a favorite quotation by someone you admire. Write the HTML code to display the person’s name in a heading and the quotation in a blockquote element. Provide Screenshot for output.

refer to the attached document.

 using the database and tables from Week Two, write SQL statements and enter five additional records into the employee table. Check the results by selecting all of the columns from both of your tables
 

Using the database and tables in Week Two, write SQL queries using various commands:
Using the COUNT command, how many employees are over age 47?
Write a SQL query that joins two tables in your database and uses BETWEEN to restrict record selection. (Use salary to restrict the data.)
Using the HAVING command, how many positions have more than 3 employees? (e.g. Cashiers, 4)
 

Using the updated database, write the following queries:
Use the COMPUTE command to generate a grand total for all of the exempt employees salaries.
Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use zip codes to restrict data.)
Create a query that shows all employees whose name has the second letter of either an ‘a’,’e’,’o’ or ‘u’.
Human Resources has requested a listing of employees. They want the listing to show the first initial of the employee’s last name. In addition, they want the report in the following sort order: exempt/non-exempt status, the first letter of their last name, last name, first name and salary. For example: Exempt, S, Smith, Bob, $50,000
 

Due to a corporate mandate, all employees who are “Asst. Manager”, must have their job title changed to “Sr. Supervisor’.

 Submit your Literature Review and Reference Page. Please use the attached rubric to guide you. 

Times New Roman 12 pt font, double spaced

MIS602-Assessment-1-Modelling-report-on-existing-practices (PART I & PART II)

Course: MIS602 Data Modelling & Database Design

Assessment 1 Modelling report on existing practices

Context:

The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment. 

Introduction:

This assignment is based on the following scenario:

ABC library is a small community library in the northern suburbs of Adelaide. In the recent years, its collection of books and the number of registered users have increased significantly facing difficulties in manually handling its main functions efficiently. To improve its services, the senior management of the library has considered a computerized library management system. The library has a rich collection of books with different genres such as fiction, biography, and history to name a few. The main functions considered for computerizing include searching of book collection based on author name, book title and genre. For this, the system should allow common functions including add, delete and modification of book details. Similarly, the library also wants to keep records of all the transactions— book issue and return. Finally, the system should allow the library staff to view all transactions and associated borrowers (library members) for each transaction, transaction date and the library staff who handled each transaction.

This assessment comprises of TWO parts. 

PART I 

Requirements: Based on this scenario, you should identify key business data objects and their attributes and define them as columns in a spreadsheet using MS excel or similar software. For this you are required to create multiple versions, ideally one file with 4 sheets with each sheet numbered with the version number, of the spreadsheet file as per below instruction: 

· Version 1 (V1.0): List all the data objects and their attributes as columns, and then add at least 10 rows of data. 

· Version 2 (V1.1): Update last 2 records (highlight in blue) and add 5 additional records (highlight in yellow) to each data object identified. 

· Version 3 (V1.2): Add 2 new attributes (highlight in red) to each data object identified. 

· Version 4 (V1.3) : Remove 1 existing attribute from each data object and add 5 more rows of data (highlight in green). 

After completing the spreadsheet versions, you are required produce and experience/reflection report (1000 words) in a word document summarizing your experience of doing these tasks. 

Submission: Your submission must composed of the following files, which must be submitted to Blackboard on or before Week 4, Thursday 23:59 (Sydney time) 

1. Spreadsheet file. 

2. Experience/Reflection report (Approximately 1000 words) in a word document summarizing your experience of doing this assignment.

Note: On the following day, you will receive another student’s spreadsheet via email to review, for which you are required to write a short critique. This is explained in the following section. 

PART II:

Requirements: Based on the spreadsheet you received, you are required to write a critique of approximately 500 words. Please note that your critique should provide constructive feedback highlighting the strengths and areas for improvement in the report, as well as any new knowledge gained from evaluating the authors report. You should provide feedback on overall design of the database, and fulfil the following minimum requirements: 

· Comment on the overall design of the database including the appropriateness of data objects and the attributes taken into consideration. 

· Provide constructive criticism on how author could enhance the overall database design, data objects and attributes. 

· Provide at least 4 useful readings the author may peruse to enhance understanding of business data objects and their characteristics. 

Submission: Your submission must composed of the following file(s), which must be submitted to Blackboard in a single zipped file on or before Week 4, Sunday 23:59 (Sydney time). 

1. Critique of 500 words.

2. The author’s report, which your critique was based upon. 

produce a Matlab/Octave script that takes an m × n matrix A and transforms it into a row equivalent matrix in RREF. This script may not use any matlab functions except size. You can and should use for and/or while loops.

 Hello please help with this assignment, it’s my final test to finish my course.

I want to ask that i can work anyone can trust me full time work hard and work all assignment as you want thank you