Purchase Solution

Primary and Foreign key fields

Not what you're looking for?

Ask Custom Question

Please see the attached and design the layout for each question in Word. Thank you.

1. How would you divide these fields in order to avoid redundancy? Lay out the different tables that you would propose creating, with the fields that would be in each of the tables. Be sure to use the Leszynski Naming Convention for all object names.

2. Which fields would be defined as the Primary and Foreign key fields in each table?

3. What type of relationship would you create between the tables? Which fields would be joined to which other fields?

Attachments
Purchase this Solution
Solution Summary

Primary and foreign key fields are discussed.

Purchase this Solution
Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic Networking Questions

This quiz consists of some basic networking questions.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

View More Free Quizzes
Related BrainMass Solutions

  • Designing a database for university

    Each non key field should relate to all fields making up the primary key. A multiple field primary key field refers to two fields in a table that together create a unique key.

  • MS acess: Setting up the keys

    Table: DRIVER LOG Primary key: Segment_ID, Driver_ID, Start_date and Start_time Reason: None of the fields or combination of fields in this table would be able to uniquely identify each record.

  • relational database

    Here are the tables and their fields, with "pk" for primary key and "fk" for foreign key. Remember, no two items of data from a primary key field can be alike. It is a good idea to put "tbl" in front of all table names.

  • Creating a Database for an Educational Institution

    TABLE 3 Field Name Data Type Description Field Size Other ContractID Text Primary key 4 Caption = Contract ID StudentID Text Foreign key 7 Caption = Student ID TeacherID Text Foreign key 7 Caption = Teacher ID LessonType Text 25 Caption = Lesson

  • Relational data model

    What tables are you are going to use in this project, what are the appropriate fields and size for each field, and why? Specify the primary and foreign keys for each table and the links between the tables.

  • Ms Access

    Now that Phil has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. c. What data type should Phil use for the Hourly Pay Rate field? Why? d.

  • Important information about Database Definitions Exercise

    Primary Key- A primary key is an exclusively identifying key in the design of a database table. f. Foreign Key- A foreign key is a database key utilized as a reference which relates separate entities to one another.

  • Database Design

    (1) Parent: Insert new row - always ok (2) Update primary key - disallow if parent has child (3) Delete row - disallow if parent has child (4) Child: Insert new row - parent must exist first (5) Update foreign key - new foreign key must match

  • Creating a databse using Microsoft SQL Server

    The primary key from the Job_title table will appear as a foreign key in the Employee table.

View More Related Solutions