country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ISYS617 Data And Information Management

tag 0 Download2 Pages / 258 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: ISYS617
  • University: Australian Institute Of Higher Education
  • Country: Australia

Question:

The second milestone will assess your abilities to transit to design and create a solution. This includes re-assessing the business requirements established in the first milestone (making adjustments to them if necessary), and creating complete database system specifications that meet these (revised) equirements. This milestone includes three stages: (I) revise conceptual database design (II) logical database design (III) Physical Database design Essentially the requirement document contains the following major sections: 

(I) REVISED CONCEPTUAL DATABASE DESIGN (Please highlight the changes to your design from ment 1)
1. Create Entity Relationship (ER) diagram as the result of conceptual database design
that involve these steps:
Step 1.1 Identify entities
Step 1.2 Identify relationships
Step 1.3 Identify and associate attributes with entities or relationships
Step 1.4 Determine attribute domains
Step 1.5 Determine candidate, primary, and alternate key attributes
Step 1.6 Check model for redundancy
Step 1.7 Check model supports user transactions
Step 1.8 Review conceptual database design with users
The ER diagram contains the following details:
1. All entities
2. Relationship - roles and multiplicities
3. All attributes for all entities
4. Primary Key for all strong entities. (refer to figure below)
5. (Note: For weak entities, you will identify primary in during logical database design.)
Deliverable example
(II) LOGICAL DATABASE DESIGN
 Conduct Logical database design includes the following steps:
Step 2.1 Derive relations for logical data model
Step 2.2 Validate relations using normalisation
Step 2.3 Validate relations against user transactions
Step 2.4 Define integrity constraints
Step 2.5 Review logical database design with users
Step 2.6 Check for future growth
1. Create table showing all entities, attributes, primary key and one or more foreign
keys, as well as with all necessary referential constraints.
Deliverable Example
(III) PHYSICAL DATABASE DESIGN
Physical database design for relational database
Step 3 Translate logical data model for target DBMS
– Step 3.1 Design base relations
– Step 3.2 Design representation of derived data
– Step 3.3 Design general constraints 
Step 4 Design file organizations and indexes
– Step 4.1 Analyze transactions
– Step 4.2 Choose file organization
– Step 4.3 Choose indexes
– Step 4.4 Estimate disk space requirements
Step 5 Design user views
Step 6 Design security mechanisms
Step 7 Consider the introduction of controlled redundancy
Step 8 Monitor and tune the operational system
Deliverables and Marks Allacation for Physical Datbase Design At this phase, you will only be eveloping a database for storing and retrieving information about the AusED Academic Staff. You need to create tables, Queries and forms using MYSQL and LibreOffice Base. You also need to create SQL queries and views, normalised tables and create E-R Diagrams.

  1. 1. Create EER diagram in MYSQL Workbench. Use MSQL workbench to create ad EER
    diagram(tables, relationships, PK, FK, indexes) based on your logical database design

  2. 2. Create database
    2.1 Use MYSQL workbench to forward engineer to create database in MYSQL server.
    Further, create any appropriate database views, stored procedures, triggers.
    2.2 Enter database records into your tables (minimum 10 records in each table) 
    3. Create Form using LibreBase (3 marks)
    3.1 Create a LibreBase from for HR Manager to enter the information about AusED’s employee
    3.2 Create a LibreBase From HR Manager to enter information about the allocation of subject per Academic Staff
    3.3 Create a LibreBase Form for Academic Staffs to enter the weekly timesheet
    4. Create the following Queries (MySQL Work Bench or LibreBase): HR Manager wants to see the following queries:
    1. List of all Employees and their contact details (sorted by Last Name, then First Name).
    2. List and total number of all full-time Academic Staff and their location.
    3. List and total number of all part-time Academic Staff and their location.
    4. List and total number of sessional Academic Staff and their location.
    5. List the names of all academic staff and the type of work they are doing.
    6. List the combined total hours worked of all the academic staff per week, the maximum hours worked, minimum hours worked, the name and subject of the academic staff who had the aximum hours , the name and subject of the academic staff who had the minimum hours worked.
    7. List the names and location of all of the academic staff teaching a subject (subject will be inputted by the HR Manager). For example, if the HR Manager entered ISYS617, only names and location of academic staff teaching ISYS617 will be shown in the report.
    8. List of how many subjects each academic staff is teaching (show the first name , last name and the number of subjects being taught).
    9. List of academic staff, their subject and their total hours worked per week per
    academic staff.
    10. List the names of all employees and how long they have worked for AusED.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 2 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Data And Information Management. Retrieved from https://myassignmenthelp.com/free-samples/isys617-data-and-information-management/database-system.html.

My Assignment Help (2020) Data And Information Management [Online]. Available from: https://myassignmenthelp.com/free-samples/isys617-data-and-information-management/database-system.html
[Accessed 23 January 2021].

My Assignment Help. 'Data And Information Management' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/isys617-data-and-information-management/database-system.html> accessed 23 January 2021.

My Assignment Help. Data And Information Management [Internet]. My Assignment Help. 2020 [cited 23 January 2021]. Available from: https://myassignmenthelp.com/free-samples/isys617-data-and-information-management/database-system.html.


Getting nightmare regarding pending chemistry assignment? Then it is high time you consider hiring chemistry assignment help service of MyAssigemnthelp.com. We at MyAssignmenthelp.com deliver quality subject specific assistance on more than 100+ subjects. For us, students' need is foremost, and we work round the clock to offer science, humanities and commerce assignment help. Among Commerce wing, our one of the most popular services is capital budgeting assignment help. In science segment, we have gained popularity with biology assignment help.

Latest Database Samples

ICT702 Data Visualization

Download : 0 | Pages : 5

Answer: For improving the business there are many parts need to upgrade. Human errors leads to huge losses to the organization. Errors are common for everyone but sometimes minimal errors leads to big problem. This topic also states the human error in the ice cream store that leads to business loss. In this assignment the management of the ice cream shop wants implement the automation system for the entire billing system. Because this process ...

Read More arrow

ITSU2004 Systems Analysis And Design

Download : 0 | Pages : 13
  • Course Code: ITSU2004
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: Manual systems and operations have often placed a lot of pressure on employees to be extra careful and do tasks in the right way every time, but the problem is that human is to error and they are prone to do them many times. Productivity, performance, and quality of services in manual system is solely depended on the person doing it, therefore, this requires that the business carries out regular training for its employees so as to enab...

Read More arrow

BSB123 Data Analysis

Download : 0 | Page : 1

Answer: The current problem is a case of testing of hypothesis regarding mean lifetime ( ) of light bulbs. The standard deviation of light bulb has been provided as hours. Assumption: Let the random variable X denotes the lifetime of the light bulbs, where it is assumed that X follows Normal Distribution, (Park, 2015). Step 1: The null hypothesis is constructed as, Step 2: The alternate hypothesis is taken as, {two-tailed} Step 3: The leve...

Read More arrow

ITECH1103 Big Data And Analytics

Download : 0 | Pages : 2
  • Course Code: ITECH1103
  • University: Federation University Australia
  • Country: Australia

Answer: Cryptography In cryptography, a hash value is a numeric value which is used to uniquely identify data and it has a fixed length in string values. Since hash values represent data of large amounts as well as smaller numeric values, they apply digital signatures in their operations (Lefebvre, Czyz & Macq, 2003, p. 496). Hash values are mostly used to store passwords in a database. 1. In order to have a successful message authentic...

Read More arrow

ITECH1100 Understanding The Digital Revolution

Download : 0 | Pages : 4
  • Course Code: ITECH1100
  • University: Federation University Australia
  • Country: Australia

Answer: Paperback Land is a small organization for selling and buying book. This book shop is run by three different employees. Andrew and Bhavesh are the semi-retired co-owners of the bookshop, and do not take a salary. Chad is a part time employee and its total employment cost is $22 per hour. In task 1, the total annual cost is calculating for this bookshop in a excel sheet. This sheet includes different type of working rate, working hours,...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,550,214

Orders

4.9/5

Overall Rating

5,109

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

265 Order Completed

97% Response Time

Ken Campbell

MSc in Electrical Engineering

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

440 Order Completed

99% Response Time

Jack Arens

MBA in HRM

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

798 Order Completed

97% Response Time

Benjamin Blakeman

MSc in Medical Technology

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

234 Order Completed

100% Response Time

Samantha Ji

PhD in Chemistry with Specialization in Organic

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Will use again, sometimes I have issues getting the creative part of writing going and love being able to reach out to help with drafts

flag

User Id: 436303 - 23 Jan 2021

Australia

student rating student rating student rating student rating student rating

The best way to paraphrase is to change every few words in the sentence or paragraph I want to use in my assignment.

flag

User Id: 160343 - 23 Jan 2021

Australia

student rating student rating student rating student rating student rating

good and excellent I am satisfied with your work. All the work done on time. Experts are good.

flag

User Id: 160343 - 23 Jan 2021

Australia

student rating student rating student rating student rating student rating

One of the best service in the Market. The assignment was completed in time, and I\'ve got a perfect rewrite option as well. The IT Support helped me to deal with all the technical issues. The Sales Department was polite and attentive. Definitely sho...

flag

User Id: 577967 - 23 Jan 2021

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?