Answered step by step
Verified Expert Solution
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
Table name: Secretary
Table name: Lawyer
Table name: Cars
Table name: ParaLegals
Table name: SecretaryAssign
Table name: Pay
\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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started