Welcome to Live Chat

Welcome to LiveWebTutors Services, World's leading Academic solutions provider with Millions of Happy Students.

Call Back
logo

24x7 Support Available

To Get the Best Price Chat With Our Experts

chat now

In A Hurry? Get A Callback

shopping cart 0

Subject Solutions Code Description Price Delete

Amount Payable : $0

continue shopping proceed to checkout

World's Leading Assignment Library

BN204- Database Technologies

Question Preview:

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 “MITtraining” that satisfies the constraints and user view requirements given below. In order ...

View Complete Question >>

Question Preview:

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 “MITtraining” 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. Foreach job posting, the date, application deadline ofthe 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, telephonenumber 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 representthese entities (or Tables) and attributesas 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 underlineit. 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. Showevery 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, thesemust 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. 4.Give one example of a type report that can be obtained from this“MIT training” database.  

View Less >>

Solution Preview

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

User view 1 requirement:  Below is given the list of entities required for this view-
Entities List:
1.Students
2.Jobopenings
3.Companies
4.Interviewers
    
User view 2 requirement:  Below is given the entities discovered in view 2-
Entities List:
1.Job opening

question Get solution

$10

Orginal Price : $13.0

Pay Now

Upload Assignments

250 words

side

Get Your Assignment

Don’t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

CUSTOMER REVIEWS

Excellent

logo

Based on 702 reviews See all reviews here

One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane

Very Helpful Customer Service

I was quite unsure about getting my assignment written online but after coming across LiveWebTutors.com, all my worries have vanished. The quality of the assignments written by their writers is just invincible. Their customer support is very polite and helpful. You should try their service at least once

Kabir
Adelaide