{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment_report_template - Part 2 Tables and keys Table 2...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
115.107 Management Information Systems Assignment Report Your name Your student ID Table of contents List of tables List of figures This document is a template for the assignment report. This is not a normative document in this paper. There is no requirement to follow it. You can modify it any way you like to make it fit your interpretation of the assignment. You can ignore it completely. Use it only if you find it useful. This template may not cover all aspects of the assignment. It is your responsibility to ensure that your submission fulfils all of the requirements as given in the assignment specification. If there is a contradiction between the assignment specification and the template, the assignment specification should take precedence.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Part 1: ER diagram Figure 1: ER diagram (extended to incorporate the scenario about online resources) Assumptions: Assumption 1 Assumption 2 ... Table 1: Attributes Entity type Attributes Key attribute
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Part 2: Tables and keys Table 2: Database tables Database table Columns Primary key Comments Part 3: Queries Figure 2: Query "listing all titles published in 1999 and later" - query design Figure 3: Query "listing all titles published in 1999 and later" - query output Figure 4: Query "listing books borrowed by customers registered on Turitea campus" - query design Figure 5: Query "listing books borrowed by customers registered on Turitea campus" - query output Figure 6: Database report "listing books borrowed by customers registered on Turitea campus" Part 4: Spreadsheet filters and pivot tables Figure 7: Spreadsheet data with no filters or conditional formatting applied Figure 8: Spreadsheet data with the "show only books published in 1999 and earlier" filter applied Figure 9: Spreadsheet data using "conditional formatting to show publication years later than 1990 as underlined" Figure 10: Pivot table Figure 11: Pivot table as a bar chart...
View Full Document

{[ snackBarMessage ]}