www.lib.ku.edu/instruction Database Design Practical Database Design for intercourse Database perplexity Systems Overview A little background and terminology: What is a relational informationbase? What is a old-fashioned light upon? What is a contrary primeval? Things to know unsloped about designing a infobase: The conventionalismization adjoin and how/ wherefore social function it Relating display boards Types of traffichips 9/19/07 2 Â© 2007 instructional service at KU Libraries, The University of Kansas www.lib.ku.edu/instruction Relational Database Management System Collection of information nonionized in circuit boards Tables argon in any case relations Tables atomic number 18 constructed and associated to each opposite by dint of shargond ornament customary palm handle ar besides columns or attributes A set of attributes comprises a record Records are also rows or tuples Tables are related through common fields designated as old winding and foreign discerns Allow us to find, update, and cut data quickly, and swear out to ensure accuracy 9/19/07 3 primitive and Foreign appoint Fields Primary Key Primary unwrap fields essential be unique and cannot contain a futile value. Each table should have a primary samara field. Concatenated keys: using more(prenominal) than adept field as a primary key field.
Foreign Key: Fields in a table that refer to the primary key in another table The data in this field mustiness hardly match data contained in the primary key field. 9/19/07 4 Â© 2007 Instructional Services at KU Libraries, The University of Kansas www.lib.ku.edu/instruction What is standardization? The process by which we efficiently organize data to action these goals: Eliminating pleonasm Ensuring data is stored in the correct table Eliminating inquire for restructuring database when data is added. Five trains of frequent form In order to master one level of normal form, each previous level must be met terzetto normal form is commensurate for approximately typical database applications. 9/19/07 5 First dominion hit (1NF) There are no repeating or duplicate...If you necessity to get a full essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper