New

Connect on Whatsapp : +97143393999 , Uninterrupted Access, 24x7 Availability, 100% Confidential. Connect Now

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ISYS617 Data And Information Management

tag 0 Download 2 Pages / 258 Words tag 24-11-2020

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

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 18 August 2022].

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 18 August 2022.

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


We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?