Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the Legal Office database for the tables below, what would be the primary/foreign keys, and what do they reference? Table name: Employee Table name:

In the "Legal Office" database for the tables below, what would be the primary/foreign keys, and what do they reference?

Table name: Employee

image text in transcribed

Table name: Secretary

image text in transcribed

Table name: Lawyer

image text in transcribed

Table name: Cars

image text in transcribed

Table name: ParaLegals

image text in transcribed

Table name: SecretaryAssign

image text in transcribed

Table name: Pay

image text in transcribed

\begin{tabular}{l|r} SID & SSpeed \\ \hline AB29gn123 & 76 \\ TR26gn 974 & 92 \end{tabular} \begin{tabular}{|l|l} LID & Lgrade \\ \hline CD48gn189 & Fed \\ \hline CB67gn328 & State \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline VEmplD & Vehicleld VLicPlate VMake & VModel & VColor \\ \hline YU84gn876 & P-29-A & MMMMM & Toyota & Corolla & Black \\ \hline DD94gn847 & M-46-B & ART-387 & Honda & Civic & Red \\ \hline FH12gn387 & M-125 & MAG 249 & Honda & CRV & Black \\ \hline CD48gn189 & M-147 & MDT 699 & Subaru & SVX & Red \\ \hline CB67gn328 & O-147 & MAD 297 & Mercury & Tracer & Gold \\ \hline TR26gn 974 & P-255-A & DFG 942 & Nissan & Tercel & Hunter Green \\ \hline AB29gn123 & C-158 & BAD & Toyota & Celica & Opal \end{tabular} PID ParaType YU84gn871Tax DD94gn84 Civil FH12gn38: Tax \begin{tabular}{r|l|l} AsID & SeclD & Assignedto \\ \hline 1 & AB29gn123 & CD48gn189 \\ \hline 2 TR26gn 974 & CB67gn328 \\ \hline 3 AB29gn123 & YU84gn876 \\ \hline 4 TR26gn 974 & DD94gn847 \\ \hline 5 TR26gn 974 & FH12gn387 \end{tabular} PID Phourly Pemp

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MySQL/PHP Database Applications

Authors: Brad Bulger, Jay Greenspan, David Wall

2nd Edition

0764549634, 9780764549632

More Books

Students also viewed these Databases questions

Question

2. What are your challenges in the creative process?

Answered: 1 week ago