Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what is a real world senario i can use to complete this task. Table one has to be connnected to table 2 , and table
what is a real world senario i can use to complete this task. Table one has to be connnected to table and table to table
Describe the design ideas of your tables, fields and relationships. This includes table structure descriptionswhat fields does each table have, and which field is a primary key field definitions for each field, describe that field name, field type and field length and relationship definition among tableseg In table XXX XXX is the foreign key connecting to the primary key XXX in table XXX
You can use a format of your choice or a table like this:
table#Tables,Fields,RelationshipstableSTUDENTStudentIDFirstNameMiddleNameLastNameDateOfBirthAdvisorIDtableStudentID: AutoNumber, LongInteger;FirstName: Short Text, ;MiddleName: Short Text, ;Las
tName: Short Text, ; c Create querys thatd are realated to the tables created
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