This Unit will be assessed by an Assignment.
You are strongly advised to read “Preparation guidelines of the Coursework Document” before answering your assignment.
Case Study: Database Management System for a Property Renting Business for Students Accommodation
A small family business known as ULKOM Housing has been runninga Property Renting Business for students in the South East of England. One of the famous universities in the UK has relocated a campus in the South East of England and ULKOM Housing has made a contract with the University to provide students’ accommodation.
The ULKOM Housing have been operating on an outdated office based systems, therefore the sudden changes in their business have led to low transaction rate, too many errors and reduced the communication and sharing of information within the company. Therefore, the newly appointed Director decided to develop a database management system to reduce errors and improve efficiency.
The database management system (DBMS) should include the customer’s details, type of property and facilities of the property and duration of the stay. Students provide letter of reference, deposit and a month advance payment. The reference letter should be endorsed by the housing agent and the agent must include his/her name and the address of the property. The student details, including in full name, address, phone number are entered into the database management system. The type of properties available for renting includes detach, semi -detached, terraced, bungalow and flat. A student could rent a property that is furnished, partly furnished or unfinished. A student could rent the property for short term (three months) or long term (a year).
As a junior database developer who recently graduated from BTEC L4 College in London, you have been recruited by ULKOM Housing to help them develop a database for supporting and effectively managing the operations the DBMS.
Your duties include the following:
· Initial discussions with ULKOM Housing to produce the user and system requirements.
· Design the database from the user requirements indicating the necessary keys and relationships. Draw ERD diagram for the entities along with their attributes such that the database is in the third normal form (Apply 1NF, 2NF and 3NF).
· Develop the database system from the user and system requirements with suitable database management system.
Summary: Design a relational database that is capable of maintaining Student Details, Property Details, Renting Details and Payment Details, Agent Details..
LO1: Use an appropriate design tool to design a relational database system for a substantial problem
It is important to show the different components of the case study data that illustrates the logical structure of the tables that makes up the database. In this view, you are required to illustrate the data structures and relationship of the tables extracted by designing the Entity Relational Diagram. Your implementation should illustrate at least four (4) inter-related tables resolving “many to many”relationships if there are any. It is necessary to explain any assumptions made for the user and system requirements.
From the tables extracted, ensure to list all the attributes. The aim of normalization is to reduce duplications. You are to produce a well normalized database up the third Normal Form following your listing specifically identifying the primary and foreign keys. The effectiveness of database design is usually assessed through testing. Assess your database design in relation to the user and system requirements.
After a successful database design, the next step is to develop the database using the structured query language. Using your design as a guide, use a suitable DBMS, for example Microsoft SQL Server 2012 (or above) to develop your database system. The tables created must be populated with records of at least five (5) entries for each table. Produce screenshots of the tables you have created and data you have inserted in the tables. To reflect your understanding of database security and maintenance, you are required to assess how these are ensured in your implementation of the fully functional database system in accordance with users and system’s requirements.
Using Structured Query Language produce query reportand ensure your implementation is justified to meet user requirements. Produce at least 8 query reports from a single table and multiple tables. Produce screenshots of the SQL statements and the query reports, including suitable annotations. To ensure usefulness of the report, you should assess whether a meaningful data were extracted from the query report.
You should discuss the effectiveness of the DBMS you have developed, the query reports and the tools have used in developing the DBMS in relation to user and system requirements, and suggesting improvements.
LO3: Test the system against user and system requirements.
It is necessary to test database and in the process of successfully carrying out testing, a test plan suffice. In your report, outline how the system has been tested against users and system’s requirements. This test plan preferably to be in a table format illustrating at least six (6) records tested. Ensure to have “Test Description”, “Expected Outcome”, “Actual Outcome” as headings. The “Actual Outcome” heading should include a visual representation such as screenshots of results and annotations.
From the test plan created, you are to explain the different database testing techniques and assess with evidence, one of the testing techniques implemented on your database development. You are required to implement and test the verification and validation process with above query transaction from the database illustrating the understanding of the various features of SQL (update, sorting, joining tables, conditions using the where clause, grouping, set functions, sub-queries etc.). In your report, include recommendations on how you can improve your database development.
Documentation helps in understanding the concept of database development. To reflect your understanding of technical and user documentation, you are required to produce a fully technical and user documentation for your designed database for the college. Your documentation should include diagrams showing movement of data through the system, and flowcharts describing how the system works.
Enhancing database development is paramount in completing the development cycle. You are required to assess any future improvements that may be required to ensure the continued effectiveness of the database system.
To gain a Pass in a BTEC HND Unit, you must meet ALL the Pass criteria; to gain a Merit, you must meet ALL the Merit and Pass criteria; and to gain a Distinction, you must meet ALL the Distinction, Merit and Pass criteria.
2. Preparation guidelines of the Coursework Document
a) All coursework must be word processed.
b) Document margins must not be more than 2.54 cm (1 inch) or less than 1.9cm (3/4 inch).
c) Font size must be within the range of 10 point to 14 point including the headings and body text.
d) Standard and commonly used type face such as Times new Roman or Arial etc should be used.
e) All figures, graphs and tables must be numbered.
f) Material taken from external sources must be properly refereed and cited within the text using Harvard standard
g) Do not use Wikipedia as a reference.
h) Word limit must be strictly followed.
3. Plagiarism and Collusion
Any act of plagiarism or collusion will be seriously dealt with according to the regulations. In this context the definition and scope of plagiarism and collusion are presented below:
Plagiarism is presenting somebody else’s work as your own. It includes copying information directly from the Web or books without referencing the material; submitting joint coursework as an individual effort.
Collusion is copying another student’s coursework; stealing coursework from another student and submitting it as your own work.
Suspected plagiarism or collusion will be investigated and if found to have occurred will be dealt with according to the college procedure. (For details on Plagiarism & Collusion please see the student hand book)
a) Initial submission of coursework to the tutors is compulsory in each unit of the course.
b) Student must check their assignments on ICON VLE with plagiarism software TurnItIn to make sure the similarity index for their assignment stays within the College approved level. A student can check the similarity index of their assignment three times in the Draft Assignment submission point located in the home page of the ICON VLE.
c) All Final coursework must be submitted to the Final submission point into the unit (not to the Tutor). A student would be allowed to submit only once and that is the final submission.
d) Any computer files generated such as program code (software), graphic files that form part of the coursework must be submitted as an attachment to the assignment with all documentation.
e) The student must attach a tutor’s comment in between the cover page and the answer sheets in the case of Resubmission.
Make backup of your work in different media (hard disk, floppy disk, memory stick etc) to avoid distress for loss or damage of your original copy
6. Extension and Late Submission
a) If you need an extension for a valid reason, you must request one using an extenuating circumstances request form available from the college exam office and ICON VLE. Please note that the lecturers do not have the authority to extend the coursework deadlines and therefore do not ask them to award a coursework extension. The completed form must be accompanied by evidence such as a medical certificate in the event of you being sick
b) Late submission will be accepted and marked according to the college procedure. It is noted that late submission may result in grading from PASS.
7. Submission deadlines
Submit to: Online to the ICON VLE only
Analyse: Break an issue or topic into smaller parts by looking in depth at each part. Support each partwith arguments and evidence for and against (Pros and cons).
Critically Evaluate/Analyse: When you critically evaluate you look at the arguments for and againstan issue. You look at the strengths and weaknesses of the arguments. This could be from an article you read in a journal or from a text book.
Discuss: When you discuss you look at both sides of a discussion. You look at both sides of thearguments. Then you look at the reason why it is important (for) then you look at the reason why it is important (against).
Explain: When you explain you must say why it is important or not important.
Evaluate: When you evaluate you look at the arguments for and against an issue.
Describe: When you give an account or representation of in words.
Identify: When you identify you look at the most important points.
Define: State or describe the nature, scope or meaning.
Implement: Put into action/use/effect
Compare: Identify similarities and differences
Explore: To find out about
Recommend: Suggest/put forward as being appropriate, with reasons why
Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...
55 - Completed Orders
Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...
52 - Completed Orders
Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...
102 - Completed Orders
To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...
109 - Completed Orders
JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...
202 - Completed Orders
Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...
20 - Completed Orders
Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...
100 - Completed Orders
Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...
200 - Completed Orders
I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...
109 - Completed Orders