Advanced Data Modeling
The resulting database will have:
create database students; create table class ( class_id char(5) primary key, class_name char(29) ); create table student ( name char(35) primary key ); create table intersect ( begin_date integer, end_date integer, status char(9), current_grade integer, my_students char(5) references class, my_classes char(35) references student );
When navigating the relationship between the class and student table the SQL optimizer will have the option to use the network model sets or the primary key columns (which are indexed).
Get started with Raima Database Manager today
Try Raima Database Manager for free today and see how screaming fast data management can get you to market on schedule and under budget.