TAILIEUCHUNG - Lecture Business system development - Lecture 15: Designing databases

In this lecture, we will: Define key database design terms, explain the role of database design in the IS development process, transform E-R or class diagrams into normalized relations, merge normalized relations from separate user views into a consolidated set of well-structured relations. | Business System Development CSC581 Lecture 15 Designing Databases 2 Summary of the previous lecture In previous lecture, we : Defined four types of business rules. Compared the capabilities of class diagrams vs. E-R diagrams. Related data modeling to process and logic modeling. Outlines We today’s lecture we will: Define key database design terms. Explain the role of database design in the IS development process. Transform E-R or class diagrams into normalized relations. Merge normalized relations from separate user views into a consolidated set of well-structured relations. Choose storage formats for fields. Translate well-structured relations into database tables. Explain when to use different types of file organizations. Describe the purpose and appropriate use of indexes. Logical Database Design Based upon the conceptual data model Four key steps Develop a logical data model for each known user interface for the application using normalization principles. Combine normalized data

• Thương mại điện tử
• Designing databases
• Business system development
• Information systems
• Information systems analysis
• Application software
• Systems development
• Lecture Designing databases
• Databases and database management systems
• Components of a DB and DBMS
• DBMS important capabilities
• relational databases
• Partial display of relational database
• Database normalization
• Systems Analysis and Design
• Data Storage
• Entity Subtype
• Table Files
• Systems Analysis
• Design in a Changing World
• OO data models
• Database management system
• Designing effective output
• Designing effective input
• Human computer interaction
• Designing accurate data entry procedures
• Quality assurance
• Designing clinical research
• Alternative trial designs
• Implementation issues
• Designing studies
• Utilizing existing databases
• International studies
• Structuring system logical requirements
• Essentials of systems analysis
• Designing the human interface
• Systems implementation
• Visual Web
• Designing a Web Site
• PPQ Database
• Modifying Databases in VWD
• XML Data
• XML
• Data Display Controls
• Human Computer Interface
• Designing for Cognitive Styles of Individual Users
• Pivot Tables
• Visual Analysis of Databases
• Physical Considerations in HCI Design
• Management information systems
• Information age
• Information technology
• Entity relationship diagramming
• Designing Your Web Pages
• Validating User Input
• Introduction to Databases
• Personalizing Web Sites
• Deploying Your Web Site
• Configuring SQL Server 2005
• Conceptual data modeling
• Structuring system requirements
• The human interface
• Lecture Information systems
• Relational database model
• Data relationships
• curriculum
• data management
• SQL Server 2000
• Microsoft SQL Server
• Databases
• công nghệ thông tin
• tin học
• mạng
• internet
• web
• quản trị mạng