BUSI 3402 Lecture Notes - Lecture 7: Xml, Database Model, Third Normal Form
Document Summary
Cardinality in entity relationship: number of instances of entity a that can be linked with each instance of entity. Logical: accounts for each data element on input or output of the system. Physical: translates relationships(definitions) into database tables, sql. Every nonprimary attribute is determined by entire primary key. Nonprimary attributes can not be dependant on each other: functional dependency. Value of a determines the value of b for all valid inputs. Design and integrate network: make all units of the system can communicate between each other, considerations. Design the application architecture: platform, programming languages, technologies, make sure program can communicate on a software level. Design user interface (gui: how user will interact with the system, based on requirements, should be very user friendly, simple and easy to use. Design system interface: how the parts of the system will connect to each other, how the system will link with other systems. Design and integrate database: choose database management system platform.