Database Fundamentals | My Assignment Tutor

Kent Institute Australia Pty. Ltd.Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458Version 2: 11th October, 2019 Page 1 of 4 TEQSA Provider Number: PRV12051ASSESSMENT BRIEF COURSE: Bachelor of Business/ Bachelor of ITUnit Code:DBFN212Unit Title:Database FundamentalsType of Assessment:Task 3- Individual ProjectLength/Duration:N/AUnit Learning Outcomesaddressed:a) Design and build relational databasesb) Define views and formulate efficient queries using a query language andc) Be knowledgeable about issues relating to data access and retrieval, storage,ethics and privacySubmission Date:To be submitted in week 11Assessment Task:The design, building, and querying of a relational database.Total Mark:30 MarksWeighting:30%Students are advised that submission of an Assessment Task past the due date without a formallysigned approved Assignment Extension Form (Kent Website MyKent Student Link> FORM – AssignmentExtension Application Form – Student Login Required) or previously approved application for otherextenuating circumstances impacting course of study, incurs a 5% penalty per calendar day,calculated by deduction from the total mark.For example. An Assessment Task marked out of 40 will incur a 2 mark penalty for each calendar day.More information, please refer to (Kent Website MyKent Student Link> POLICY – Assessment Policy &Procedures – Student Login Required) Kent Institute Australia Pty. Ltd.Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458Version 2: 11th October, 2019 Page 2 of 4 TEQSA Provider Number: PRV12051ASSESSMENT DESCRIPTION:This assessment is an individual Project.The manager of a consulting firm has asked you to evaluate a database that contains the table structure shownin the Table 1 below. Attribute NameSample ValueSample valueSample ValueCLIENT_NUM298289289CLIENT_NAMEMarianne R. BrownJames D. SmithJames D. SmithCLIENT_REGIONMidwestSoutheastSoutheastCONTRACT_DATE10-Feb-202015-Feb-202012-Mar-2020CONTRACT_NUMBER584158425843CONTRACT_AMOUNT$2,985,00.00$670,300.00$1,250,000.00CONSULT_CLASS_1Database AdministrationInternet ServicesDatabase DesignCONSULT_CLASS_2Web ApplicationsDatabase AdministrationCONSULT_CLASS_3Network InstallationCONSULT_CLASS_4CONSULTANT_NUM_1293425CONSULTANT_NAME_1Rachel G. CarsonGerald K. RicardoAngela M. JamisonCONSULTANT_REGION_1MidwestSoutheastSoutheastCONSULTANT_NUM_2563834CONSULTANT_NAME_2Karl M. SpenserAnne T. DimarcoGerald K. RicardoCONSULTANT_REGION_2MidwestSoutheastSoutheastCONSULTANT_NUM_32245CONSULTANT_NAME_3Julian H. DonatelloGeraldo J. RiveraCONSULTANT_REGION_3MidwestSoutheastCONSULTANT_NUM_418CONSULTANT_NAME_4Donald ChenCONSULTANT_REGION_4West Table 1: Sample CLIENT RecordsTable 1 was created to enable the manager to match clients with consultants. The objective is to match a clientwithin a given region with a consultation in that region and to make sure that the client’s need for specificconsulting services is properly matched to the consultant’s expertise. For example, if the client needs help withdatabase design and is located in the Southeast, the objective is to make a match with a consultant who islocated in the Southeast and whose expertise is in database design. (Although the consulting company managertries to match consultant and client locations to minimise travel expense, it is not always possible to do so.) Thefollowing basic business rules are maintained:Kent Institute Australia Pty. Ltd.Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458Version 2: 11th October, 2019 Page 3 of 4 TEQSA Provider Number: PRV12051• Each client is located in one region.• A region can contain many clients.• Each consultant can work on many contracts.• Each contract might require the services of many consultants.• A client can sign more than one contract, but each contract is signed by only one client.• Each contract might cover multiple consulting classifications. (For example, a contract may listconsulting services in database design and networking.)• Each consultant is located in one region.• A region can contain many consultants.• Each consultant has one or more areas of expertise (class). For example, a consultant might be classifiedas an expert in both database design and networking.• Each area of expertise (class) can have many consultants. For example, the consulting company mightemploy many consultants who are networking experts.Tasks to be completed:a) Given this brief description of the requirements and the business rules, write the relational schema anddraw the dependency diagram for the preceding (and very poor) table structure. Label all transitiveand/or partial dependencies.b) Break up the dependency diagram you drew in task (a) to produce dependency diagrams that are in 3NFand write the relational schema. (Hint: You might have to create a few new attributes. Also make surethat the new dependency diagrams contain attributes that meet proper design criteria; that is, makesure there are no multivalued attributes, that the naming conventions are met, and so on.)c) Using the results of task (b), draw the Crow’s Foot ERD.d) Create a database using MySQL, with primary keys, foreign keys, and other attributes mentioned foreach entity of the ERD in task (c) using proper constraints.e) Populate each of the tables created in task (d) with some significant data (See Table 1 for sample data)f) Create FOUR queries. (One SELECT, one Numeric function and two JOIN).ASSESSMENT SUBMISSION:The assignment must be submitted online in Moodle. The ERD and dependency diagram must be in MS WORDand assignment submission should contain both MS WORD file and the actual database contained in one folder.MARKING GUIDE (RUBRIC): Marking CriteriaLecturer ExpectationMarksCommentsERDProper diagrammatic representation ofentities, attributes, identifiers, andrelationships10NormalisationReflect understanding of dependenciesand normalization.4Database, tables,keys, fields, and dataShows understanding of MySQL as arelational DBMS and how it supportsdatabase design and implementationfor relational databases.8QueriesReflect understanding SQL usingMYSQL – Four queries (one SELECT,one Numeric function and two JOIN)2×4 =8Total30 GENERAL NOTES FOR ASSESSMENT TASKSContent for Assessment Task papers should incorporate a formal introduction, main points and conclusion.Kent Institute Australia Pty. Ltd.Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458Version 2: 11th October, 2019 Page 4 of 4 TEQSA Provider Number: PRV12051Appropriate academic writing and referencing are inevitable academic skills that you must develop anddemonstrate in work being presented for assessment. The content of high-quality work presented by a studentmust be fully referenced within-text citations and a Reference List at the end. Kent strongly recommends yourefer to the Academic Learning Support Workshop materials available on the Kent Learning Management System(Moodle). For details please click the link download the file titled “Harvard Referencing Workbook”. This Moodle Site is the location for Workbooksand information that are presented to Kent Students in the ALS Workshops conducted at the beginning of eachTrimester.Kent recommends a minimum of FIVE (5) references in work being presented for assessment. Unless otherwisespecifically instructed by your Lecturer or as detailed in the Unit Outline for the specific Assessment Task, anypaper with less than five (5) references may be deemed not meeting a satisfactory standard and possibly be failed.Content in Assessment tasks that includes sources that are not properly referenced according to the “HarvardReferencing Workbook” will be penalised.Marks will be deducted for failure to adhere to the word count if this is specifically stated for the Assessment Taskin the Unit Outline. As a general rule there is an allowable discretionary variance to the word count in that it isgenerally accepted that a student may go over or under by 10% than the stated length.GENERAL NOTES FOR REFERENCINGReferences are assessed for their quality. Students should draw on quality academic sources, such as books,chapters from edited books, journals etc. The textbook for the Unit of study can be used as a reference, but notthe Lecturer Notes. The Assessor will want to see evidence that a student is capable of conducting their ownresearch. Also, in order to help Assessors determine a student’s understanding of the work they cite, all in-textreferences (not just direct quotes) must include the specific page number(s) if shown in the original. Beforepreparing your Assessment Task or own contribution, please review this ‘YouTube’ video (Avoiding Plagiarismthrough Referencing) by clicking on the following link: link: search for peer-reviewed journal articles may also assist students. These type of journal articles can be locatedin the online journal databases and can be accessed from the Kent Library homepage. Wikipedia, onlinedictionaries and online encyclopaedias are acceptable as a starting point to gain knowledge about a topic, butshould not be over-used – these should constitute no more than 10% of your total list of references/sources.Additional information and literature can be used where these are produced by legitimate sources, such asgovernment departments, research institutes such as the National Health and Medical Research Council (NHMRC),or international organisations such as the World Health Organisation (WHO). Legitimate organisations andgovernment departments produce peer reviewed reports and articles and are therefore very useful and mostlyvery current. The content of the following link explains why it is not acceptable to use non-peer reviewed websites(Why can’t I just Google?): you to La Trobe University for access to this video).


Leave a Reply

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