As a student, you take courses. These courses have books and instructors. a) List all the column names. Make sure they a

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

As a student, you take courses. These courses have books and instructors. a) List all the column names. Make sure they a

Post by answerhappygod »

As a student, you take courses. These courses have books and instructors.a) List all the column names. Make sure they are descriptive.b) For each of the 3 tables (items in bold, above), clearly identify the columnsthat belong to each table.c) List your choice of the primary key (PK) column or columns in each table.d) Identify the foreign key (FK) columns as you create relationships betweenthese tables. When you state your FK columns, make sure to identify the tablethe column(s) refer to.e) Associating actual data with tables help in understanding the underlyingrelationships between your tables. Provide some sample data for each of thetables. At least 3 rows of data in each table. For example, for a table thatholds data for NFL coaches, we may have the following data:id teamName CoachName100 Broncos Vic Fangio200 Patriots Bill Belichick300 Raiders Jon Gruden
sql in word processing
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply