Your contribution can guide someone’s learning journey. Share your
documents today.
Assignment and Report Cover Sheet 1.Complete all of the details below and sign. 2.No assignment will be accepted unless this form is completed in full, signed and dated. 3.Hand this in to your lecturer in person or submit it electronically together with your assessment STUDENT ID NUMBER:NAME OF STUDENT: (PRINT CLEARLY) FAMILY NAMEOTHER NAME(S) UNIT CODE / UNIT NAME:NAME OF LECTURER: TITLE/TOPIC OF ASSIGNMENT: “I certify that the attached assignment is my own work and that any material drawn from other sources has been fully acknowledged”. Signed:Date: PENALTIES FOR LATE ASSIGNMENTS 1.If a student is unable to submit a within-semester assessment task (i.e. assignment) on or by the due date, the penalty will be 5% per working day. The mark will be zero after 5 working days. An exception may be granted if the student applies for an extension and provides anExplained Absenceform together with: Medical certificate (signed by lecturer and given to the Welcome Centre by student), or Written explanation (signed by lecturer and given to the Welcome Centre by student), in the case of personal circumstances which have the potential to significantly affect the performance of the student. Evidence must be submitted within 3 days (or at the next scheduled class if the lecturer is not available – an email to the lecturer isalso recommended). 2.Lecturers will undertake to provide feedback within 2 weeks of due date. ACADEMIC MISCONDUCT AND PLAGIARISM Academic misconduct of any form is unacceptable. Academic misconduct includes, but is not limited to: PlagiarismFraudulently submitting work of another person Unauthorised collaboration;Theft of other students' work Cheating in assessmentsAny other fraudulent practices "Plagiarism” means to knowingly or unknowingly present as one's own work the ideas or writings of another without appropriate acknowledgment or referencing. This includes, but is not limited to: •Paraphrasing text without adequately stating the source; •Paraphrasing text inadequately with acknowledgment of the source; •Copying another student's work; and •Copying of visual representations (cartoons, line drawings, photos, paintings and software code) All forms of cheating, plagiarism or collusion are regarded seriously and may result in penalties including loss of marks, exclusion from the unit or cancellation of enrolment.Lecturers submit assessments int. TURNITIN– a programme which scans and records your work to match it against electronic works of otherson the inter Further information see: Assessment Policy and/or the Academic Misconduct Policy at: www.pibt.wa.edu.au/policie ================================================================ ASSIGNMENT RECEIPT BY LECTURE To be completed by the student as proof of submission to the Lecturer. UNIT TITLE:NAME OF STUDENT: FAMILY NAMEOTHER NAME(S) LECTURER’S SIGNATURE:NAME OF LECTURER: DATE:TOPIC OF ASSIGNMENT:
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Page3of12 1.Assumptions: - I made no assumptions and I create 11 tables according to the case study in this assignment and these tables are: - Branch table. Manager table. Clients table. Job_type table. Jobs table. Accountant_specialise table. Accountant table. Mentor table. Pay_level_detail table. Current_Pay_level table. Higher_Pay_level table. Relationships between the tables: - Jobs and Clients tables have Zero to many relationships. Jobs and Accountant have zero to many relationships. Jobs and Job_type have zero to many relationships. Accountant_specialise and Job_type tables have one to many relationships. Accountant_specialise and Accountant tables have one to many relationships. Branch and Manager Tables have one to one relationships. Mentor and Accountant tables have zero to many relationships on Accountant_ID in Mentor table. Mentor and Accountant tables have one to one relationship on Mentor_Acc_ID in Mentor table. Branch and Accountant tables have one to one relationship. Current_Pay_level and accountant tables have one to one relationship. Current_Pay_level and Pay_level_detail tables have one to one relationship.
Page4of12 Current_Pay_level and Higher_Pay_level tables have one to one relationship.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Page8of12 3.Branch table Columns NameKey TypeNull/UniqueFK TableFK ColumnData typeLengthDetail Branch_IDPKUINTEGER10 Manager_IDFKManagerManager_IDINTEGER10 Accountant_IDFKAccountantAccountant_IDINTEGER10 Branch_nameVARCHAR50 B_addressVARCHAR100Branch address B_Phone_numberVARCHAR20Phone number of branch 4.Client table Columns NameKey TypeNull/UniqueFK TableFK ColumnData type LengthDetail Client_noPKUINTEGER10Client number Tax_file_noVARCHAR20 First_nameVARCHAR50 Last_nameVARCHAR50 Contact_numbe r VARCHAR20 Email_IDVARCHAR50
Page9of12 5.Job_type table Columns NameKey TypeNull/UniqueFK Table FK ColumnData typeLengthDetail Job_type_noPKUINTEGER10Job type number Job_type_nameVARCHAR30 Cost_per_mintDOUBLECost per minute 6.Jobs table Columns NameKey Type Null/UniqueFK TableFK ColumnData type LengthDetail Job_IDPKUINTEGER10 Client_IDFKClientClient_IDINTEGER10 Accountant_IDFKAccountan t Accountant_IDINTEGER10 Job_type_noFKJob_typeJob_type_noINTEGER10 Job_dateDATEThe date of the job Start_timeTIMEThe time that the job was started Completed_timeTIMEThe time that the job was completed NoteVARCHARAny notes or extra details about the job (no size limit) Partial_paidDOUBLE Left_amountDOUBLE Total_costDOUBLE
Page10of12 7.Accountant_specialise table Columns Name Key Type Null/UniqueFK TableFK ColumnData type LengthDetail Acc_speci_noPKUINTEGER10Accountant specialize number Accountant_IDFKAccountan t Accountant_IDINTEGER10 Job_type_noFKJob_typeJob_type_noINTEGER10 8.Mentor table Columns NameKey TypeNull/ Unique FK TableFK ColumnData typeLengt h Detail Mentor_noPKUINTEGER10 Mentor_Acc_IDFKAccountantAccountant_IDINTEGER10accountant’s mentor Accountant_IDFKAccountantAccountant_IDINTEGER10Accountant 9.Pay_level_detail table Columns NameKey TypeNull/UniqueFK Table FK ColumnData type LengthDetail Pay_level_noPKUINTEGER10 Pay_level_nam e VARCHAR50 Annual_payDOUBLE
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Page11of12 Min_ExpINTEGER5Minimum Experience 10.Higher_Pay_level table Columns NameKey Type Null/UniqueFK Table FK Column Data type LengthDetail Higher_Pay_levelPKUINTEGER10 Exp_in_otherVARCHAR255previous experience in other accounting firms Annual_payDOUBLE 11.Current_Pay_level table Columns NameKey Type Null/UniqueFK TableFK ColumnData typeLengthDetail Crr_Pay_level_noPKUINTEGER10 Accountant_IDFKAccountantAccountant_IDINTEGER10 Pay_level_noFKPay_level_detailPay_level_noINTEGER10 Higher_Pay_level_n o FKHigher_Pay_levelHigher_Pay_levelINTEGER10 SalaryDOUBLE
Page12of12 References Allen, C., Chatwin, S., & Creary, C. (2004).Introduction to relational databases and SQL programming. Berkeley, Calif: Osborne/McGraw-Hill. Connolly, T., & Begg, C. (2015).Database systems. Boston [u.a.]: Pearson. Connolly, T., Begg, C., & Holowczak, R. (2008).Business database systems. Harlow, England: Pearson Education. Garmany, J., Clark, T., & Walker, J. (2005).Logical database design principles. Boca Raton, Fla. [u.a.]: CRC Press. Harrington, J., & Harrington, J. (2009).Relational database design. Burlington, MA: Morgan Kaufmann/Elsevier. Hernandez, M. (2013).Database design for mere mortals. Harlow: Addison-Wesley. Kelly, L. (2004).Physical Database Design Using Oracle. Boca Raton: C R C Press LLC. Kim, H. (2012).Advances in Technology and Management. Berlin, Heidelberg: Springer Berlin Heidelberg. Li, Q. (2008).Conceptual modeling. Berlin [u.a.]: Springer. MacWhinney, B. (2000).The database. Hillsdale [u.a.]: Lawrence Erlbaum Ass. Silberschatz, A., Korth, H., & Sudarshan, S. (2011).Database systems concepts. Estados Unidos: McGraw-Hill Companies, Inc. Stephens, R., & Plew, R. (2001).Database design. Indianapolis, Ind.: Sams.