Question

Relational Database

You should understand that a relational database is a collection of tables that are related to one another based on a common field. The tables within the database contain a collection of records. The records within the table contain a collection of fields. Each field in the table represents a particular characteristic of the data.

A field, or a collection of fields, is designated as the primary key. The primary key uniquely identifies a record in the table. When the primary key of one table is represented in a second table to form a relationship, it is called a foreign key.

Think about creating a database that will store information about students. Design a table that will contain information about students. You should decide on all the fields (characteristics) they would need to maintain student records. Select a field that would uniquely identify a student (usually a student ID). Explain why the student’s name would not be a good choice for the primary key Next, “fill in” the data for a particular student

Create another table that will store information about the student organizations students participate in (or extracurricular activities, sports, etc.).When you decided what the second table will be, determine the required fields. Most importantly, decide on the common field that will link these tables in a relational database.

Answer 1

data inserted for a student as requested in the question after creating tables using MS Sql server