What is an intersection table? Why is it created?
Answer to relevant QuestionsWhat is a foreign key? Discuss its importance to a relational database.Match the following database fields with the appropriate database table. (Q2.3) a. VENDOR table b. CUSTOMER table c. EMPLOYEE tabled. ACCOUNTS table e. SALES ORDER table f. SALES ORDER LINE table g. PURCHASE ORDER table h. ...Since your background is in AIS, you have been asked to provide training to the other accountants in your company about the new accounting system design. How would you explain to your colleagues about the three tiers in ...Discuss the differences between a database form to enter data and a database form to search for data. How would these differences affect the way you design these forms?The following figure shows a Microsoft Access query design screen for a vendor query. Use information provided on this figure to answer the following questions: 1. How many tables are used in this query?2. What fields will ...
Post your question