DAT702 Week 2 Lecture Three

Week 2 Lecture Three

The lines connecting each table are relationships between each other, the connection allows you to put data in the corresponding field if data is in the first field, the constraint belongs to the foreign key table, one of the most important tools networking people will do is moving data. How many people have a Royal Bank account in Canada, about 6 million, you will be bringing data in bulk, we are going to be doing it in Access as well as MySQL, Access does not like a lot of tables opened up, which table are we going to use first, courses and students, grades must be last because of the constraints, the students file is tab delimited and is correct the very first line is the headings of the table, in MySQL you cannot have headings in the file,

Now we are going to open:
File/Import/students.txt

Defaults to Delimited, Tab, Click first row contains the field names, Text Qualifier =Always None, next then loaded

Two constraints which are the students and courses to the foreign key which is the grades table, data must be imported to the constraints then when the constraints are loaded you are able to load data into the grades table. Remember the Constraints to the foreign key. Appropriately

In Access go to Query/ Right Click screen SQLView type

SELECT *
FROM students;