Construct a data dictionary based on the ERD diagram Eg Table Name Donation Column Name Description Data Type Size Primary Key Foreign Key FK referential table Donation ID Unique identification for the donation made Number 4 Yes Donation ID Donor ID Date Amount Payment Method Provides DonorT Donor ID (Mandatory,Or) OtherDonor Alumni ID Alumni Name Alumni IC Alumni Gender Company ID Industry ID Company Name Company Address Company Other Donor's ID Other Donor IC OtherDonor Email OtherDonor Address

The Answer is in the image, click to view ...

Question: Construct a data dictionary based on the ERD diagram Eg. Table Name: Donation Column Name Description Data Type Size Primary Key? Foreign Key? FK referential

Construct a data dictionary based on the ERD diagram

Eg. Construct a data dictionary based on the ERD diagram Eg. Table Name:

Table Name: Donation

Column Name	Description	Data Type	Size	Primary Key?	Foreign Key?	FK referential table
Donation_ID	Unique identification for the donation made	Number	4	Yes	-

Donation ID Donor ID Date Amount Payment Method Provides DonorT Donor ID (Mandatory,Or) OtherDonor Alumni ID Alumni Name Alumni IC Alumni Gender Company_ID Industry_ID Company_Name Company_Address Company- Other Donor's ID Other Donor IC OtherDonor Email OtherDonor Address

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This assignment allows students to demonstrate their skills in the area of designing relational databases to satisfy specific business rules and requirements. The deliverables for this assignment...

Project 1 Details: In this project you will be provided with a description of an application (below) to create an entity-relationship diagram (ERD) and design accompanying table layout using sound...

can answer questions 11 and 14 according to microsoft database Design Specifications Tracking payment details will entail the use of a combination of three (3) tables: VEHICLE, POLICY, and PAYMENT....

The objective of Project #1 is to develop a relational data model describing the primary business processes of Polytechnic Supply Corporation (PSC). PSC is in the business of Business-to-Business...

DMLab3 This lab is in two parts. The first part is worth 50 points and consists of 5 questions worth 10 points apiece from chapter 5 of the text. The second part consists of making a model of the...

Questions B1,B2, and B3 are based on the case study below: Case Study SpeedTravel Management System SpeedTravel Sdn Bhd is an e-hailing service company that provides rides in motorbikes instead of...

CIS 3650 Database Management Systems 2. Entity relationship diagram that documents the database design. The diagram should use the Fall 2022 Group Project appropriate crow's foot notation including...

20. Consider the table below. actor ie Ondore di 1d2 Which functional dependencies (fd) shows partial dependencies? A. dl (filmNo, actorNo, role timeOnScreen) and fd4 (dirNo director) B. fdl (filmNo,...

Please complete the following assignment according to instructions. The case study paper needs to be 2-3 pages long and must follow APA format. For the assignment I chose scenario 2. Thank you. 4.2 -...

Construct diagram DFD level 1 a)Diagram 1: Verify account Data dictionary based on diagram DFD level 1 a)External entity (name, description, input data, output data) b)Data Flow (name, description,...

What are three megatrend sources or categories for finding entrepreneurial opportunities?

What are the nontax costs associated with providing pension benefits for employees?

Which of the following are reasons usually given by managers for not evaluating training? Select one: Both nothing to evaluate and no one cares about the evaluation No one cares about the evaluation...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: AGING METHOD. Cindy Bagnal, the manager of Cayce Printing Service, has provided you with the following aging schedule for Cayces accounts receivable: Cindy...

(Appendices) EFFECTS OF DISCOUNTS ON SALES AND PURCHASES. Helmkamp Products sells golf clubs and accessories to pro shops. During 19x5, Helmkamp purchased merchandise with a list price of $628,500 on...

(Appendices) Compare and contrast the three major ways economies can be organized. What type of economy exists in the United States? Do you think another type of economy would be better? Explain your...