1.

The School of Information Technology & Engineering (SITE) would like to help its Master of Networking students with placement in various companies and firms. To facilitate this, they need to design a database with the primary purpose of scheduling interviews and facilitating searches by students and companies that are looking for candidates. MIT’s IT Manager provided following business rules to the software developer:

Complete the information-level design for the new database “MIT training” that satisfies the constraints and user view requirements given below. In order to complete the information-level design you are required to answer questions given below 1(a) – (e)

User view 1 requirement: The database should have information about students, job openings, companies, interviewers and interviews. Student’s first name, last name, student id number, driver’s license number and expected graduation date must be recorded.

User view 2 requirements: Companies post job openings that students can apply for. For each job posting, the date, application deadline of the posting, title of the position, base salary, minimum requirements, and description are recorded.

User view 3 requirements: One student can apply for many open positions (Job postings) in different companies, and the date and time of each application is recorded. Students should also be able to see the status of their application (whether there will be a follow-up interview and whether they were turned down for the position).

User view 4 requirements: Interviews can be facilitated by the University and interviews are conducted by the respective companies. It is required to keep track of date and time of the interview, conference room location, which employees interviewed which students, as well as the result of the interview. A company from the Business School reserves MIT conference rooms and the company needs to specify the resources needed (e.g. computer, projector, etc.).

User view 5 requirements: An interviewer is an employee of a company and he/she has an employee id, telephone number and position title.

User view 5 requirements: A company has an identifier, name, main contact number and main fax number.

a. Analyse the all user requirements, identify and list all entities described in each user requirement.

(5 Marks)

b. Add attributes to these entities and represent these entities (or Tables) and attributes as a collection of Tables and attributes. You are required to arrange them as given in the example below.

NB: Select a suitable primary key for each table and underline it.

Eg. Student (StudentID, Fname,…….

(10 Marks)

c. Outline all relationships between entities.

Eg. : One students can apply for many open positions (Job postings) in all companies – One-to-many,

(5 Marks)

d. Determine the functional dependences.

Eg. StudentID àFname, address, ……

(10 Marks)

e. Then normalise these tables. Make the normalization to 3NF. Show every step in the process.

(10 Marks)

2. Represent the structure of your database visually by using the entity-relationship (E-R) diagram. If you make any assumptions about data that doesn’t appear in the problem, these must be clearly described.

You need to use Visio or any other software tool to create the ER diagram.

(15 Marks)

3. Build this model using MS Access/MS SQL Serverby creating these tables and Relationships. Populate these tables with appropriate data, include at least 3 records in each table.

(10 Marks)

4. Give one example of a type report that can be obtained from this “MIT training” database.

(5 Marks)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1. Use Javafx: Create a Contacts application in JavaFx. Store the contacts information in an ObservableListof Contact object. A contact should contain first name, last name, email and phone number properties (You are free to provide others). When the user selects a contact from the contacts list, its information should display in a Grid of Text Fields. As the information is modified (A Contact’s data is updated, a new Contact is added or an existing Contact is deleted), the contacts ListViewshould display the updates. The ListViewshould display the Contact’s last name. Also provide a custom ListViewthat display’s the Contact’s full name and picture with the names sorted by last name.

2. Create a JavaFx mortgage calculator app that allows the users to enter a purchase price, down-payment amount and interest rate. Based on these values, the app should calculate the loan amount (purchase price minus down payment) and display the monthly payment for 10-,20- and 30- year loans. Allow the user to select a custom loan duration (in years) by using slider and display the monthly payments.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1. Usage research data elicitation homework project. The interviewers should ask the interviewees to recollect their usage of a mobile application. Focus on context, breakdowns, key tasks, ecology, and so on. Ask them to think about how that usage fits into the context of the rest of their lives. This is a case where you should ask about how they might want to use the proposed new product/system, too. Look especially for any emotional impact data and look at long-term usage, not just short snapshots of usage During the interviews, take raw data notes.
2. Build a limited WAAD (at least 2 user work roles)
-Build a limited work activity affinity diagram from the work activity notes you wrote on Post-it stick or electronic notes from question 1.
-Write the essence of the note on a Post-it or electronic note.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1
University : University of Wales
Programme : MBA
Module : Human Resources Management
Assignment Title :
A Human Resources Management Report :
The Impacts of Digital Transformation , Artificial Intelligence (AI), to Human
Resources Management.
(I) Deliver on April 10, 2019.
a/ a report of 1,500 to 2,000words
b/ 7 to 8 pages of Power Point for presentation
The details are as the following :
(A) Produce a Human Resources management report that focus on impacts of digital
transformation to HRM.
The report must contain strategies, insights, solution and conclusions derived from the
findings detailed within the report and culminate in fully justified recommendations and an
implementation plan for recommended changes.
Abbreviations should be fully spelled out in parentheses at the first time.
The report should be with logical flow.
For example, the way we lead, attract, motivate, and retain staffs, the way we lead as HR
leader and team for performance, the way to serve our stakeholders (employees / customers /
suppliers / investors / partners), the way we compete, and definitely have profound impacts to
the way we manage and drive performance effectiveness in our organization today and future.
Provide an insightful critical analytical report based on the Key Change Driver in digital
transformation.
Discuss at least 3 articles related to how the key selected driver is being adapted and impact
HR functions for higher performance today and future.
Prefer at least 3 articles (research paper) from the 8-big company in the world, such as
the audit firms and the consulting firms
• You must indicate in your report which issues you have selected.
• Your report should draw upon the theories, principles, tools and guidelines from the
field of business management given in the lectures or in the previous activities and
exercises.
2
The report should at least cover the followings:
1. Brief introduction the background and focus of the topic / key change driver
2. How organization adopts and embrace this change driver and how it affects how HR
leaders adopt these drivers and apply to allow HR to perform.
3. Key learnings (insights, lessons, observations, arguments) from the articles
4. Key impacts (positive & negative) of applying learnings in workplace
5. Key challenges for HR leaders to apply learnings into their real workplace
6. Provide recommendation / suggestion for better results
(B) Power Point and presentation
– 7 to 8 Power Point for presentation (not including the cover / end pages)
– maximum 6 to 7 points per page
– the last page is the reference
 In addition, there should be a slide with references used at the end
 The presentation needs to professionally presented, this includes professional looking
graphics
 The physical presentation of the presentation should be aimed at a professional
audience (i.e. dress code, fluent delivery in English)
3
University : University of Wales
Programme : MBA
Module : Human Resource Management
Assignment title :
A Human Resources Management Report :
The Impacts of Digital Transformation, Artificial Intelligence (AI), to Human
Resources Management.
Assignment Information
C/ Format :
1/ Harvard formatting, all references mentioned in the Reference List are cited in
the text, and vice versa.
2/ All alphabetical Citation List using Harvard referencing style.
3/ Citations, should match with Reference List.
4/ A4 size of paper
5/ Microsoft Words in 12-point type Time New Roman font
6/ with at least 2-centimetre space at each edge
7/ Format, with 1.5-line spacing for all material in the manuscript
8/ Format, using single line spacing for graphs, tables, footnotes, and reference list
9/ Section headings should be numbered in Arabic numerals (1, 2, 3),
while sub-section should follow the double numeration system (1.1, 1.2 etc.)
10/ All headings, left-aligned and in bold and on their own separate line.
11/ Figure and table, on one individual page
12/ Figures and tables should be placed above or below of the relevant text in the
manuscript, and the corresponding caption should be placed directly above the
figure or table.
13/ Variable for figure or table, to be 2 to 3, not too much.
14/ Please divide into 2 figures or 2 tables, if there are 4 or more variables
15/ Figure and table with number, and provide the sources for them
16/ With Appendices (if any), all charts, financials, visuals, and other related items.
If more than one appendix, should be identified as A, B, etc.
17/ Abbreviations should be fully spelled out in parentheses at the first time.
18/ Use first hand information all the times.
19/ Please try to use your own words and ideas based on research rather than copy
and paste other’s words from the internet.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1. Under current law, most Social Security recipients do not have to pay federal or state income taxes on their Social Security benefits. Suppose the government proposes to tax these benefits at the same rate as other types of income. What would be the impact of the proposed tax on the optimal retirement age?

2. Consider the following proposed changes to the current Social Security earnings test and determine if the changes lead to higher hours of work among retirees.

a. A change in the amount of exempt labor earnings, from $17,000 to $25,000.

b. An increase in the implicit tax rate from 33 to 50 percent.

 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"