Events Calendar

08 Mar
Faculty Colloquium: "Database Design Theory and Normalization"
Event Type

Lectures, Symposia, Etc.

Topic

Research, Technology

Target Audience

Undergraduate Students, Staff, Faculty, Graduate Students

University Unit
Department of Computer Science
Subscribe
Google Calendar iCal Outlook

Faculty Colloquium: "Database Design Theory and Normalization"

This is a past event.

AbstractNormalization is a process to verify the correctness of relational schema and provides formal guidelines on improving the schema in order to reduce data redundancy -- which causes anomalies in database systems. Normalization defines different normal forms based on the source of data redundancy in the relations.
In this lecture, I, first, introduce the functional dependencies, which describe the relationship between attributes in the relational schema. Examining the properties of functional dependencies of the schema informs us about the normal forms of the relations. Finally, I discuss methods for refining the relations into higher normal forms to reduce undesirable data redundancy.

BioDr. Riazi is a visiting assistant professor in the Department of Computer Science at the University of North Carolina-Charlotte. Prior to joining UNCC, she was an assistant professor in the Department of Computer Science at the University of New Haven. She got her Ph.D. from the University of Oregon under the supervision of Prof. Boyana Norris with a dissertation on “Distributed Memory Processing of Very Large Graphs”. Dr. Riazi's research has been focused on big data processing and data mining.

Tuesday, March 8 at 10:00 a.m. to 11:00 a.m.

Sennott Square, Room 5317
210 South Bouquet Street, Pittsburgh, PA 15260

Faculty Colloquium: "Database Design Theory and Normalization"

AbstractNormalization is a process to verify the correctness of relational schema and provides formal guidelines on improving the schema in order to reduce data redundancy -- which causes anomalies in database systems. Normalization defines different normal forms based on the source of data redundancy in the relations.
In this lecture, I, first, introduce the functional dependencies, which describe the relationship between attributes in the relational schema. Examining the properties of functional dependencies of the schema informs us about the normal forms of the relations. Finally, I discuss methods for refining the relations into higher normal forms to reduce undesirable data redundancy.

BioDr. Riazi is a visiting assistant professor in the Department of Computer Science at the University of North Carolina-Charlotte. Prior to joining UNCC, she was an assistant professor in the Department of Computer Science at the University of New Haven. She got her Ph.D. from the University of Oregon under the supervision of Prof. Boyana Norris with a dissertation on “Distributed Memory Processing of Very Large Graphs”. Dr. Riazi's research has been focused on big data processing and data mining.

Tuesday, March 8 at 10:00 a.m. to 11:00 a.m.

Sennott Square, Room 5317
210 South Bouquet Street, Pittsburgh, PA 15260

Powered by the Localist Community Events Calendar ©