Question: Hello I need help with a SQL code that will compile these few tables into folders to look like the bottom image. Its not the
Hello I need help with a SQL code that will compile these few tables into folders to look like the bottom image. Its not
the same info and the info inside the folders is not
important but im having trouble getting code to
compile into looking similar to the bottom image thank
you so much if you can help me quickly!!
This is the tables ive come up with sorry for typos it
scanned for paper:
Bank Teller Productivity Analyzer System
Table : Bank Teller Information
Primary Key: tellerid
Attribute : tellerid
Attribute : tellerposition
Attribute : tellerbranch
Attribute : tellervalue gross
Attribute : tellerhours
Table : Bank Branch Information
Primary Key: branchid
Foreign Key: tellerid
Attribute : branchid
: branch name
: branch location
: brunchvalue gross
: branch yobyears of business
Table : Productivity
Primary key: poductivityid
Forign key: tellerid
Foreign key: branchid
Atribute : productivityid
: tellerid
: branch location
: brunchvalue gross
: branch yobyears of business
Table : Productivity
Primary key: poductivityid
Forign key: tellerid
Foreign key: branchid
Attribute : productivityid
: tellerid
: branchid
: branchproductivtyvalue gross
: branchtellerproductivityvalue gross
I need it to look similar to the bottom of the picture and if you can post a screenshot of the sql I would really appreciate it thank you!!!!!
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
