Database Management - Skillage I.T. - Specialist Cars - Design Project Scenario Assignment Help

Internal Code : 2AFBF

Database Management Assignment Help

TASK You are the Database designer of a consulting company named ‘Skillage I.T.’. You have been tasked with auditing, designing, building and testing a new database for a new medium size client. You will use your newly gained knowledge to plan and manage the database project in order to facilitate a successful outcome for Skillage I.T. and the client. The project has had some preliminary work done on it and you have the following information available... (These will be provided by your instructor) ? Company Profile ? Company Scenario for Requirements ? Stakeholder interviews As the current database is relatively small and there is an understanding the issue is not server resources, please generate the following items to create a successful resolution for ‘Specialist Cars’. Choose a data modelling process, ORM, ER or UML that you will use to design your database. The deliverables include: Document detailing the reason for your choice. This should include any pros or cons that you considered in your decision making process. Produce a collection of documents and diagrams that outline the database design. The deliverables include: Two preliminary designs and a short paper on why you chose one over the other Scope Document for Database requirements Logical Data Model (suggest using Vision) i. Entity Diagram ii. Relationship Diagram iii. Attribute list Data Structure i. Primary and Foreign keys ii. Indexes iii. Data dictionary (meta data) iv. Normalisation profile An outline of – i. User Queries (Stored Procedures) ii. Output Reports iii. Security & Access design iv. Backup strategy (include log shipping) Submission of final design with signoff approval to proceed. Create the database from your design. You can download a 180 day free trial copy of Microsoft SQL 2005 or 2008 to complete this task (URLs below). Use the SQL Management Studio for build your database. The database will need to be backed up and submitted for assessment purposes, so ensure that you do not use live or confidential data in your tables. The deliverables include: a.Database build checklist b. Testing plan and checklist c. T-SQL listing for at least two stored procedures d. T-SQL listing for creation of at least two tables e. Maintenance plan f. Signoff and acceptance document (See Project Management for more information) g. Post Implementation Review template

The above question has been solved by our Database Management experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.