Hi, I need help with the following (NOTE: attached document has full instructions):
Based on the given information below create a Data Model and a Database Design, remember that the Data Model will include entities, their attributes, ad their relationships. In the Database Design the entities will be converted to tables, identifiers to primary keys, and attributes to columns. Relationships will be verified both maximum and minimum cardinality. In addition, you will add data type, data size, the primary keys, the foreign key, and the null/not null constraints. You can use any software to create your data model and data base design. After done creating both diagram, copy those diagram and paste them in a MS Word Document.
Donations
- DonationID
- Amount
- Date
- TransactionNum
- DonorID
- ProjectID
- EventID
- Donors· DonorID· FirstName· LastName· StreetAddress· City· State· ZipCode· PhoneNumber· Email
Projects
- ProjectID
- Type
- Name
- Location
- Duration
- DateOfFunding
- AmountOfFunding
- CompletionDate
Events
- EventID
- Description
- Location
- Date
- Sponsor
- EventFundingGoal
- CollectedFunds
0 comments