ACCOUNTING-The group assignment is a project which requires the design &amp

Bachelor of Business(Incorporating Graduate Diploma in Business & Graduate Certificate in Business)Business Data Management426103Group AssignmentThe group assignment is a project which requires the design & implementation of databaseusing Microsoft Access. It consists of two components: Part 1 requires you to develop an EntityRelationship diagram, relational model and a data dictionary for the project; Part 2 requires thedevelopment of a logical design, normalization, implementation of the project and a groupreport.The database design assignment is a team project with a team size of 4-5 people. Teammembers are expected to work in a harmonious and professional fashion. It is up to students tomanage the group process so that each person carries out an equal amount of work.The assignment provides an opportunity for students to work as a group, on a practical databasedesign and implementation project. It is important that the group report should be complete,well written (grammatically correct, free of spelling errors), and professionally presented.Suggested number of pages is between 10-15 excluding appendix.Assignment Submission ProcedureSubmission should include the softcopy of the database, and, both hardcopy and softcopy ofthe report on a CD. Submit the group report (soft and hard copy) in class on October 19,2015. Do not submit this assignment elsewhere.20 marks will be automatically deducted if submitted individually. 10 marks per day will bededucted from the assignment if not submitted on the due date and time.Suggested Steps:1. Select team members and form a group. Ideal size of a group would be 4 or 5 students pergroup. Group size must not exceed 5 students per group. Each student must have to be partof a group.2. Create Tables and ERD diagram. Ensure referential integrity is enforced in the design.There should be at least 6 tables per assignment. All tables must be in normalized form andany special condition should be explained in detail.3. Create Forms and design the interface. This section should include at least 3 single formsand at least one sub form. Explain the purpose of each form and ensure all forms arefunctional.4. Create Queries and explain the purpose of each query in detail. Queries must use fieldsfrom different tables. This section should include at least 4 queries. All queries should befunctional.5. Create Reports and provide an explanation on each report. This section should include atleast 4 reports and ensure reports are functional.6. Conclusion remark and finish all the content.7. Prepare individual contribution summary and attach with the group report. This summaryshould be agreed by all members.a. Each student must certify that they have completed at least one form, one query andone report.8. Sign off the cover sheet (all group members)Assessment CriteriaAssessment ComponentsProject Description and conclusionMax Marks5Database EntitiesData Dictionary and Data IntegrityEntity Relational Diagram (need to comply withnormalisation)Referential Integrity (Cardinality and connectivity isrequired)Provide Normalisation documents(35)1010FormsFunctionalInterface (user friendly)Explaination(15)771ReportsFunctionalReport PresentationExplaination(15)853QueriesQuery DesignExplaination(20)155Switch Board5Individual Contribution5510100Case NarrationDuring peak periods, John’s Employment Business (JOB) places temporary workers incompanies. JOB’s manager gives you the following description of the business:•JOB has a file of candidates who are willing to work.•If the candidate has worked before, that candidate has a specific job history.(Naturally, no job history exists if the candidate has never worked.) Each time thecandidate works, one additional job history record is created.•Each candidate has earned several qualifications. Each qualification may be earnedby more than one candidate. (For example, it is possible for more than one candidateto have earned a BBA degree or a Microsoft Network Certification. And clearly, acandidate may have earned both a BBA and a Microsoft Network Certification.)•JOB offers courses to help candidates improve their qualifications.•Every course develops one specific qualification; however, JOB does not offer acourse for every qualification. Some qualifications have multiple courses thatdevelop that qualification.•Some courses cover advanced topics that require specific qualifications asprerequisites. Some courses cover basic topics that do not require any prerequisitequalifications. A course can have several prerequisites. A qualification can be aprerequisite for more than one course.•Courses are taught during training sessions. A training session is the presentationof a single course. Over time, JOB will offer many training sessions for eachcourse; however, new courses may not have any training sessions scheduled rightaway.•Candidates can pay a fee to attend a training session. A training session canaccommodate several candidates, although new training sessions will not have anycandidates registered at first.•JOB also has a list of companies that request temporaries.•Each time a company requests a temporary employee, JOB makes an entry in theOpenings folder. That folder contains an opening number, a company name,required qualifications, a starting date, an anticipated ending date, and hourly pay.•Each opening requires only one specific or main qualification.•When a candidate matches the qualification, the job is assigned, and an entry ismade in the Placement Record folder. That folder contains an opening number, acandidate number, the total hours worked, etc. In addition, an entry is made in thejob history for the candidate.•An opening can be filled by many candidates, and a candidate can fill manyopenings.•JOB uses special codes to describe a candidate’s qualifications for an opening. Thelist of codes is shown below.JOB QUALIFICATION CODESCODEDESCRIPTIONSEC-45Secretarial work, at least 45 words per minuteSEC-60Secretarial work, at least 60 words per minuteCLERKGeneral clerking workPRG-VBProgrammer, Visual BasicPRG-C++Programmer, C++DBA-ORADatabase Administrator, OracleDBA-DB2Database Administrator, IBM DB2DBA-SQLSERVDatabase Administrator, MS SQL ServerSYS-1Systems Analyst, level 1SYS-2Systems Analyst, level 2NW-NOVNetwork Administrator, Novell experienceWD-CFWeb Developer, ColdFusion

Order your essay today and save 30% with the discount code: KIWI20