MIS602 Data Modelling and Database Design Report 1 Sample
Task Summary
This assessment requires you to prepare a modelling report that demonstrates your ability to assess business requirements along with a logical design that could be implemented in a relational database management system.
Context
When preparing to implement a new information system, it is essential that the initial design is well thought out from the outset. Modifying the database after implementation can often be an expensive process in terms of time, effort and cost. Often the first engagement step is to conduct interviews and workshops with end users and business subject matter experts to get a better understand of how the business runs. The output of these workshops becomes the foundation for the database design.
Task Instructions
Please read the attached MIS602_Assessment 1_Case Study.
Based on the information provided in the case study, prepare a modelling report to answer the following tasks:
Task 1: An entity relationship diagram including all the significant entities, attributes and their relationships. Use Crow’s foot notation.
Task 2: A relational model showing all fields, primary keys, foreign keys and concatenated keys. Your relational model should be in third normal form. List any assumptions/business rules you have made.
Task 3: A sample dummy input screen of scheduling an interview for one of the shortlisted candidates. You have to make sure all the data requirements are being captured. You may use any tool you like to create this sample screen. Write a brief paragraph of about 200 words discussing the following:
- Does your database design allow the storage of all the required information?
- What changes, if any, did you make to your initial ER diagram and relational model after you created the sample input screen?
The front-end or user interface design enables accessing the data stored in a database. Prototyping the interface also enables capturing initial system and data requirements.
Solution
Task1: An Entity Relationship Diagram (ERD)
After the study of given case study for ABC Technology company, following entities, attributes and relationship types are identified. University Assignment Help -
Entity Name & Attributesof Entity
C_JobVacancy(VacancyId , Post, Type, Description, ExpInYear, Package, Location, Priority, Criteria, Scarceness)
C_AdvtPlatform (AdvtNo, AdvtName, AdvtType, Cost)
Candidate (CandidateId, Name, PhoneNo, ExpInYears, Qualification, Previous_Exp)
C_JobInterview (InterId, Venue, InterviewDate, InterviewTime, InterviewPanel, Rating, Recommendation)
C_Manager (ManagerId , FName, LName Post, Salary, ContactNo)
C_Department (DeptID , DeptName, DeptLoc)
C_JobReferees(Ref_No, Name, CurrentPosition, CompanyName, RelationshipName)
Relationship Name (Entities Name)[Cardinality and Participation]
Approve (C_Manager and C_Job_Vacancy as well as C_Deparment and C_Job_Vacancy) Many to One [M:1] and Partial]
ManagedBy (C_Department and C_Manager) [One to One [1:1] and Full]
RequestFor (C_Manager and C_JobVacancy) [Many to One [M:1] and Full]
Post ( C_JobVacancy and C_AdvtPlatform) [Many to Many [M:M] and Partial]
RegisterFor (Candidate and JobVacancy) [Many to Many [M:M] and Partial]
AppearIn (Candidate and C_JobInterview) [Many to Many [M:M] and Partial]
NominateTo( Candidate and C_Job_Referees) [ One to Many [1:M] and Partial]
RefereesCheck ( C_Manager and C_Job_Referees)[ Many to One [M:1] and Partial]
ER Diagram
.png)
Task2: A Relational Model
A relational model equivalent to ER diagram presented here.
.png)
List of assumptions/business rules
Following business rules or assumption will be expected as outcome of database design for the ABC Technology Company.
• To find number of candidates applied for specific job vacancy vice versa.
• To compute total cost of advertisement at different platform for a specific job vacancy.
• To find number of request made by the manager to approve vacancy.
• To find number of vacancy in each department.
• To compute average cost paid to job ads platform by a department.
Task 3: A sample Dummy Input Screen
Here, a sample input screen is created which represent post job vacancy advertisement on different platform by the department.
• Does your database design allow the storage of all the required information?
Designed database for the ABC Technology company allows stakeholders to manage their records and activities such as department, job vacancy, advertisement platforms, job registration, interview, advertising process etc. It overcomes the issues of manual process for keeping and managing records.
• What changes, if any, did you make to your initial ER diagram and relational model after you created the sample input screen?
No changes made in the initial entity relationship diagram and relational model after the creation of sample input screen because database design derives all requirements of effective database application. Each field of sample input screen is stored in the job advertisement platform as well as department tables. It will not miss to store any information that supplied in the sample input screen. It is all happens because the relational model is normalized up to third normal form.
References
Coronel, C., & Morris, S. (2018). Database systems: design, implementation & management (13th ed.). Cengage Learning US. https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2378339.
Harrington, J. L., & Harrington, J. L. (2016). Relational database design and implementation (Fourth). Morgan Kaufmann/Elsevier.
Lukaszewski, A. (2010). Mysql for python. Packt Pub. Retrieved April 8, 2022, from https://lesa.on.worldcat.org/oclc/696354563
Parker, J. R. (2021). Python : an introduction to programming (2nd ed.). Mercury Learning & Information. Retrieved April 8, 2022, from https://lesa.on.worldcat.org/oclc/1243551836
Stephens, R. (2009). Beginning database design solutions (Ser. Wrox beginning guides). Wiley Pub.
Teorey, T. J. (2011). Database modeling and design : logical design (5th ed., Ser. The morgan kaufmann series in data management systems). Morgan Kaufmann
Would you like to schedule a callback?
Send us a message and we will get back to you
Highlights
Earn While You Learn With Us
Confidentiality Agreement
Money Back Guarantee
Live Expert Sessions
550+ Ph.D Experts
21 Step Quality Check
100% Quality
24*7 Live Help
On Time Delivery
Plagiarism-Free
81 Isla Avenue Glenroy, Mel, VIC, 3046 AU
