Lecture - Information Retrieval

Lecture - Information Retrieval - ACCT361...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style ACCT-361 Accounting Information Systems Class 6 Information Retrieval from RDMS Example of Project 1 Presentation
Background image of page 1

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

View Full DocumentRight Arrow Icon
Advantages of the Relational Approach n Database technology provides the following benefits to organizations: q Data integration q Data sharing q Reporting flexibility q Minimal data redundancy and inconsistencies q Data independence q Central management of data q Cross-functional analysis
Background image of page 2
Example Custo mer Invent ory Cashie r Cash Receip t Cash Sales Person Sale (1,*) (1,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Example (partial database) Inventory-Sale Inventory ItemID Sale Number Quantity Actual Price A-4 S-1 2 600 A-1 S-1 3 2,000 A-6 S-2 2 5,000 A-1 S-3 1 2,000 A-5 S-3 2 4,000 A-3 S-3 6 1,000 A-6 S-4 2 5,000 A-2 S-5 2 3,000 A-4 S-5 2 300 A-6 S-5 2 5,000 A-2 S-6 10 3,500 A-6 S-7 2 7,000 A-5 S-7 3 3,000 Sale Sale# Amount Date Cust# SalesRep# S-1 7,200 1 July C-1 E-12 S-2 10,000 21 July C-2 E-10 S-3 16,000 22 July C-5 E-10 S-4 10,000 26 July C-2 E-10 S-5 16,600 31 July C-5 E-10 S-6 35,000 15 Aug C-3 E-10 S-7 23,000 21 Aug C-4 E-99 Sale-CashRec Sale# RA# Applied S-2 RA-1 1,666 S-4 RA-2 10,000 S-1 RA-3 7,200 S-3 RA-4 16,000 S-5 RA-4 16,600 S-2 RA-5 1,666 Customer Customer# Name State SP# C-1 Bill DC E-12 C-2 Mick MD E-10 C-3 Keith DC E-10 C-4 Charlie VA E-99 C-5 Ron VA E-10 Obj104 Obj105 Salesperson SP# Name Comm rate E-12 Karen .12 E-10 Connie .10 E-99 Heather .10 E-78 John .15
Background image of page 4
What is Querying? n It is asking questions about the data in the database and manipulating or combining the data in different ways n We can isolate certain rows in tables, we can isolate certain columns in tables, we can join tables together, we can create calculations based on various data items, etc.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Querying/Information Retrieval Requirements for effective querying 1. A database that is well-designed n If tables are not fully relational or incompletely specified, or if conceptual model has not been correctly converted into relational form, querying will be difficult or impossible 2. A query developer who understands the table structures and the nature of the data in the tables 3. A query developer who understands the desired query output 4. A query developer who has good logic and reasoning skills 5. A query developer who knows the querying language used to retrieve information from the enterprise database
Background image of page 6
Two Query Languages n Structured Query Language (SQL) q The user enters commands according to a pre-defined syntax to retrieve desired data. n
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 25

Lecture - Information Retrieval - ACCT361...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online