tblCustomer tblContacts tblTerritories
sngCID (PK) sngCTID (PK) sngTCodeNo (PK)
strCName strCTFName strTCodeName
strCAddr strCTLName
strCCity strCTPosition
strCState sngCTPhone
sngCZip * strTTitle
memCStatus sngCID (FK)
sngTCodeNo(FK)
strSalesRepID(FK)
tblSalesReps tblProducts tblOrders
sngSalesRepID(PK) sngPCode (PK) sngPCode
strSalesRepLName strPDesc sngCID (FK)
strSalesRepFName strPCategory sngSalesRepID(PK)
sngSalesRepPhone sngPSize sngOrderQty
sngSalesRepHrs strPFinish dtmOrderDate
dtmSalesRepHireDate curPListPrice dtmOrderFillDate
sngTCodeNo(FK) sngPDiscount * ysnOrderStatus
sngSalesRepID(FK)
Computer Science Homework Solutions
#21090
Excel
I need your help on visualizing the attached data in Word to excel. Please see attached and do the following questions in Excel. Thank you very much.
1. create all of the tables for the database.
2. Define all fields.
3. Set captions for all fields.
4. Create all necessary and appropriate relationships.
What is this?
By OTA - Overall OTA Rating
Suraj Joshi, PhD (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
- Plain text response
- Attached file(s):
- db1.mdb
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Create the keys and relationships between tables for the Driver LOG - Using MS Access, create the keys and relationships between tables for the Driver LOG from the file attached.
- Implement the spreadsheet in the MS access and list all assumptions and functional dependencies - (See attached file for full problem description) --- Implement the database in MS access with Relationships, tables, keys, indexes and a view(query) that duplicated the spreadsheet and list all fu ...
- Create the keys and relationships between tables - Using MS Access, I need to create the keys and relationships between the tables for the Driver LOG attached.
- database - Please find the attached and give me your idea about the attached database, (since I can not attach access file, please change the file extension to database.mdb when open) *Very brief explanation ...
- Database Concept - What is an ERD and why are they important for a database?
