















































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
An overview of database development, including the database development process, information engineering, and alternative approaches to database and is development. It covers concepts such as data modeling, entity-relationship diagrams, and database schema. The document also discusses the systems development life cycle and prototyping methodology.
Typology: Study notes
1 / 55
This page cannot be seen from the preview
Don't miss anything!
1
Chapter 2 2
Chapter 2 4
(^) A data-oriented methodology to create and maintain information systems
(^) Four steps:
Chapter 2 5
Chapter 2 7 Information Engineering Planning Phase: Step Explanation
Chapter 2 8
Chapter 2 10 Continued…. Business Functions Business planning Product development Material management Order fulfilment Order shipment Sales summerisation Product operation Finance and accounting Entity types CUSTOMER PRODUCT RAW MATERIAL ORDER WORKC CENTER INVOICE EQUIPMENT EMPLOYEE
Chapter 2 11
Information system Transaction processing system Order tracking Order processing Plant scheduling Payroll Management Information System Sales Management Inventory control Production scheduling
Chapter 2 13
Chapter 2 14 Segment from enterprise data model (Pine Valley Furniture Company) [simplified E-R diagram, repeat of figure 1.3] Enterprise data model describes the entities in an organization and the relationship between these entities
Chapter 2 16
Chapter 2 17 Example business function-to- Example business function-to- data entity matrix data entity matrix Business Planning X X X X Product Development X X X X Materials Management X X X X X X Order Fulfillment X X X X X X X X X Order Shipment X X X X X X Sales Summarization X X X X X Production Operations X X X X X X X Finance and Accounting X X X X X X X X Customer Product Raw Material Order Work Center Work Order Invoice Equipment Employee Business Function (users) Data Entity Types
Chapter 2 19 Systems Development Life Cycle Systems Development Life Cycle (figures 2.4, 2.5) (figures 2.4, 2.5) Project Identification and Selection Project Initiation and Planning Analysis Physical Design Implementation Maintenance Logical Design
Chapter 2 20 Systems Development Life Cycle Systems Development Life Cycle (figures 2.4, 2.5) (figures 2.4, 2.5) Project Identification and Selection Project Initiation and Planning Analysis Physical Design Implementation Maintenance Logical Design Purpose --preliminary understanding Deliverable –request for project Database activity – enterprise modeling