Posted: December 11th, 2024

Database Assessment Assignment 2 Database Technologies

Assessment Details and Submission Guidelines
Unit Code BN204
Unit Title Database Technologies
Assessment Type Assignment 2
Term, Year T2, 2018: 2024 - Write My Essay For Me | Essay Writing Service For Your Papers Online
Assessment Title Data model development and implementation
Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain understanding of data model development. Then implement the data model using a commercially available database management system development tool.
On completion of this assignment students will be able to:
• Make an informed and critical assessment of database management systems.
• Develop data models and implement DB systems.
• Analyse business decisions related to DB information systems.
• Demonstrate skills in building a database application using a commercially available database management system development tool.

Weight 70 + 30 for the quiz
Total Marks 20% of total assessment for the unit
Word limit No specific word limit
Due Date Lab class week 11

What Citation Formats Do You Support?

We hear “Can you write in APA or MLA?” all the time—and the answer’s a big yes, plus way more! Our writers are wizards with every style—APA, MLA, Harvard, Chicago, Turabian, you name it—delivering flawless formatting tailored to your assignment. Whether it’s a tricky in-text citation or a perfectly styled reference list, they’ve got the skills to make your paper academically spot-on.

Description of this assignment: This assignment consists of two parts:
Part A: An online quiz Assignment 2, which includes 30 questions. Students may have 3 attempts at this quiz. The system will select the highest grade.
Part B: The creation of an ER diagram and implementation
Submission Guidelines • All work must be submitted on Moodle by the due date. Write your answers in this document underneath the question and save as
“BN204_T2_2018: 2024 - Write My Essay For Me | Essay Writing Service For Your Papers Online_Assigment2_your_name.doc”.

• The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.5 cm margins on all four sides of your page with appropriate section headings.
• Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using IEEE referencing style.
• Submit both the database that you created and the word document.
Extension • If an extension of time to submit work is required, a Special Consideration Application must be submitted directly to the School's Administration Officer, in Melbourne on Level 6 or in Sydney on Level 7. You must submit this application three working days prior to the due date of the assignment. Further information is available at:
https://essays.homeworkacetutors.com/write-my-essay/mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/specialconsiderationdeferment

Academic Misconduct
• Academic Misconduct is a serious offence. Depending on the seriousness of the case, penalties can vary from a written warning or zero marks to exclusion from the course or rescinding the degree. Students should make themselves familiar with the full policy and procedure available at: https://essays.homeworkacetutors.com/write-my-essay/mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/Plagiarism-Academic-Misconduct-Policy-Procedure. For further information, please refer to the Academic Integrity Section in your Unit Description.

 

Are Paper Services Legal?

Yes, completely! They’re a valid tool for getting sample papers to boost your own writing skills, and there’s nothing shady about that. Use them right—like a study guide or a model to learn from—and they’re a smart, ethical way to level up your grades without breaking any rules.

Assignment Description

Part A: (30 marks)
Paste below the summary of your Moodle Assignment 2 quiz. The quiz will be open after week 8

Part B: (70 marks)

How Much for a Paper?

Prices start at $10 per page for undergrad work and go up to $21 for advanced levels, depending on urgency and any extras you toss in. Deadlines range from a lightning-fast 3 hours to a chill 14 days—plenty of wiggle room there! Plus, if you’re ordering big, you’ll snag 5-10% off, making it easier on your wallet while still getting top-notch quality.

1. Knox private Hospital contracted with GeenIT services to develop and design their hospital database, the hospital IT Get research paper samples and course-specific study resources under   homework for you course hero writing service - Manage r provided the following business rules to the GreenIT services software developer:

User view 1 requirement : Patients are identified by a PatientID, and their names, addresses, and ages must be recorded.

User view 2 requirement : Doctors are identified by a DoctorID. For each doctor, the name, specialty, and years of experience must be recorded.

User view 3 requirement : Every patient has a primary physician/doctor. Every doctor has at least one patient.

Will Anyone Find Out I Used You?

Nope—your secret’s locked down tight. We encrypt all your data with top-tier security, and every paper’s crafted fresh just for you, run through originality checks to prove it’s one-of-a-kind. No one—professors, classmates, or anyone—will ever know you teamed up with us, guaranteed.

User view 4 requirement : Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription can have more than one drug.

User view 5 requirement: For each drug, identified by DrugID and the trade name and formula must be recorded.

User view 6 requirement: Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.

User view 7 requirement: Each pharmacy has a unique name, address, and phone number.

Do You Rely on AI?

Not even a little—our writers are real-deal experts with degrees, crafting every paper by hand with care and know-how. No AI shortcuts here; it’s all human skill, backed by thorough research and double-checked for uniqueness. You’re getting authentic work that stands out for all the right reasons.

Complete the information-level design for the database that satisfies the above constraints and user view requirements. In order to complete this information-level design you are required to answer questions given below 1(a) – (f).
1.
a. Analyse the all user requirements given above, identify and list all entities described in all 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. (10 Marks)
NB: Select suitable primary key for each table and underline them.
Eg. Patient (PatientID, name,…….)
c. Outline at least 2 relationships between those entities. (5 Marks)
Eg. Every patient has a primary physician/doctor. - One-to-many.

d. Determine the functional dependences. (10 Marks)
Eg. PatientID  name, address, age, ......

e. Normalise the tables. (10 Marks)

Why Are You Top for Research Papers?

Our writers are Ph.D.-level pros who live for nailing the details—think deep research and razor-sharp arguments. We pair that with top plagiarism tools, free revisions to tweak anything you need, and fast turnarounds that don’t skimp on quality. Your research paper won’t just shine—it’ll set the bar.

2. Represent the structure of your database visually by using the entity-relationship (E-R) diagram. If you make any assumptions about data that are not explicitly given in the problem, these must be 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 by creating these tables and Relationships in Access. Populate these tables with appropriate data, at least 2 records in each table. Include following into your MS Word document.

I. Relationship diagram created in Access. (Select database tools Relationships in the Access menu)

II. Data sheet view and design view of your tables. Eg.

Who’s Behind My Essays?

You’re in good hands with degree-holding pros—many rocking Master’s or higher—who’ve crushed our tough vetting tests in writing and their fields. They’re your partners in this, hitting tight deadlines and academic standards with ease, all while tailoring every essay to your exact needs. No matter the topic, they’ve got the chops to make it stellar.

Figure 1 Data Sheet view

Figure 2 Design View
(5 marks x 2 =10 Marks)

4. Give one example for the type of report that can be obtained from this “Knox private” database.
(5 Marks)

 
Marking criteria:
Example of marking criteria is shown in the following table. Marks are allocated as follows:

Is My Paper Original?

100%—we promise! Every paper’s written fresh from scratch—no AI, no copying—just solid research and proper citations from our expert writers. You can even request a plagiarism report to see it’s 95%+ unique, giving you total confidence it’s submission-ready and one-of-a-kind.

Section to be included in the report Description of the section Marks
1.
a. Identify all entities Identify entities in all user requirements 5
b. User Views as Tables Represent the User Views as a collection of Tables 10
c. Relationships Determine the relationships between entities 5
d. Functional dependences. Determine Functional dependences. 10
e. Normalise tables Analyse above tables and normalise these 10
2.
ER Diagram Represent the structure of your database visually by using the ER diagram. Write a word essay - Evaluate your proposed solutions 15
3. Model building Model building on MS SQL Server 10
4. Report Generation Example report 5
Total marks or the Report 70
Assignment 2 Quiz marks Marks for Assignment 2 Quiz 30
TOTAL 100

Example Marking Rubric for Assignment 2 Report: Total Marks 70 for the report

Grade
Mark HD
100% DISTINCTION
80% CREDIT
60% PASS
40% Fail
0-40%
User Views as Tables
Ability to think critically and analysed clearly
Relevant and soundly analysed.
Generally relevant and analysed.
Some relevance and briefly presented. Not relevant to the assignment question.
Relationships

Demonstrated excellent ability to think critically and identified relationships Demonstrated good ability to think critically and identified relationships. Demonstrated ability to think critically and identify some relationships Demonstrated some ability to think critically.

Can You Do Any Citation Style?

Yep—APA, Turabian, IEEE, Chicago, MLA, whatever you throw at us! Our writers nail every detail of your chosen style, matching your guidelines down to the last comma and period. It’s all about making sure your paper fits academic expectations perfectly, no sweat.

Did not demonstrate ability to think critically

Normalise Logic is very clear and easy to follow
Logic is clear and convincing
Mostly consistent and logical
Adequate cohesion and conviction
Arguments are confused and disjointed
Dependency

All elements are present and very well integrated. Components present and well integrated Components present and mostly well integrated Most components present Representation lacks structure.
ER Diagram

Extremely good effort. All elements are present and very well integrated.
Outstanding Good effort. Most components are present and well integrated Good effort made but not outstanding Made some effort with inaccuracies Very little attempt. Lazy effort with inaccuracies
Model building
Extremely good effort. All elements are present Good effort. Most components are present Good effort made but some components are missing Made some effort with inaccuracies Very little attempt. Lazy effort with inaccuracies

Tags: 1500 Words Assessment Brief, Create a 4–6 page, Discussion Assignment, Do My Assignment for Me Online - Write Academic Papers