Database Technologies Assessment

Assessment Details and Submission Guidelines Unit Code BN204 Unit Title Database Technologies Assessment Type Assignment 2 Term, Year T3, 2017 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 60 + 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 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_T3_2017_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. 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: 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: For further information, please refer to the Academic Integrity Section in your Unit Description.   Assignment Description Part A: (30 marks) Paste below the summary of your Moodle Assignment 2 quiz. The quiz will be open after week 7 Part B: (60 marks) 1. SmartProjects Company is planning to design a data model to hold information relating to their projects, employees working on company projects and their customers. SmartProjects IT Manager provided following business rules to the software developer: 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) – (e) User view 1 requirement: Each employee has a unique ID number, and their first name, last name, date of birth, address, contactNo user name and password must be recorded. There is a need to keep track of the dependents of each employee for insurance purposes. User view 2 requirements: Each customer has a unique Cust_number and their first name, last name, address, PNum, project tile and Payment must be recorded. User view 3 requirements: Each project has a project number that uniquely identifies the project (PNum) and project title, StartDate, managerID, managerName,managerContactNo must be recorded. User view 4 requirements: An employee can work on only one project. A project can have one or more employees associated with it. User view 5 requirements: Each department has a unique ID number and name. A Department can have many employees. An employee can only work in one department. A department controls number of projects. User view 6 requirements: One project may belong to several departments. One customer can submit only one project at one time. a. Analyse the all user requirements given above, identify and list all entities described in each 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. NB: Select suitable primary key for each table and underline them. Eg. Customer (CustomerID, name,……. (5 Marks) c. Outline all relationships between entities. Eg. One project may belong to several departments – One-to-many, (5 Marks) d. Determine the functional dependences. Eg. CustomerID  name, address, …… (10 Marks) e. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency that causes it. (10 Marks) 2. Represent the structure of your database visually by using the entity-relationship (E-R) diagram. If you make any assumptions about data that doesn’t show from the problem, they must be described. You can use Visio or any other software tool to create the ER diagram. (15 Marks) 3. Build this model using MS SQL Server by creating these tables and Relationships. Populate these tables with appropriate data, at least 3 records in each table. (10 Marks)   Marking criteria: Example of marking criteria is shown in the following table. Marks are allocated as follows: Section to be included in the report Description of the section Marks 1. a. identify all entities Identify entities all user requirements 5 b. User Views as Tables Represent the User Views as a collection of Tables 5 c. Relationships Determine the relationships between entities 5 d. Functional dependences. Determine Functional dependences. 10 e. Normalise tables Analyse above tables and normalise 10 2. ER Diagram Represent the structure of your database visually by using the ER diagram. Evaluate your proposed solutions 15 3.Model building Model building on MS SQL Server 10 Total marks or the Report 60 Assignment 1 Quiz marks Marks for Assignment 1 Quiz 30 TOTAL 90 Example Marking Rubric for Assignment 2 Report: Total Marks 60 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. 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 pre
sent Good effort made but some components are missing Made some effort with inaccuracies Very little attempt. Lazy effort with inaccuracies

Leave a Reply

Your email address will not be published. Required fields are marked *