1 / 5

BUAD 283: Management Info Systems

BUAD 283: Management Info Systems. Database Design Assignment #1. Glen J. Coulthard, Instructor Faculty of Business, OUC. Specific Requirements (1/2). Report Structure: Letter of Understanding (LU) or Transmittal Memo (TM) A. Statement of Problem or Opportunity

cissy
Download Presentation

BUAD 283: Management Info Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BUAD 283: Management Info Systems Database DesignAssignment #1 Glen J. Coulthard, InstructorFaculty of Business, OUC

  2. Specific Requirements (1/2) • Report Structure: • Letter of Understanding (LU) or Transmittal Memo (TM) • A. Statement of Problem or Opportunity • B. Description of Entity Classes (Tables) • C. Identification of Attributes (Fields) and Keys (PK and FK) • D. Diagram of Logical Relationships (E-R diagram) • E. Discussion of Relationship Rules, Constraints, & Assumptions • F. Proposed Report Structures (min 3 pages; max 5) • G. Summary/Conclusion: How does this solve my problem? • Appendices: E-R Diagram, Sample Reports, Data Dictionary • No Executive Summary necessary; info contained in LU or TM

  3. Specific Requirements (2/2) • If used, please cite references properly using “APA Style” • Not www.zdnet.com; instead, use:Doherty, S. (2002, March 18). Managing data. Ziff-Davis Publishing. [On-line]. Retrieved from http://www.zdnet.com/1306ws1.htm. • Not “Management Information Systems textbook;” instead, use:Haag, S., Cummings, M., et al. (2004). Management information systems for the information age. Toronto, ON: McGraw-Hill Ryerson.

  4. Data Modeling Concepts • Logical versus Physical • Logical: Entity Relationship (E-R) diagramming • Physical: Creating and relating tables in Microsoft Access • Basic components of an E-R Diagram • Entity (Table) • Attribute (Field) • Relationship • Basic components of a Data Dictionary

  5. E-R Diagramming Software Tools • Microsoft ExcelUse the drawing tools • Microsoft Visio drawing programhttp://www.microsoft.com/office/visio • CASE Studio 2 by CharonWarehttp://www.casestudio.com/ • DeZign for Databases by Datanamichttp://www.datanamic.com/dezign • DDS-Lite or DDS-Pro from Chilli Sourcehttp://www.dds-lite.comhttp://www.dds-pro.com

More Related