Assignment Objective: The goal of this assignment is to devclop database modcl and database design that will assist in understanding the relational database. Before we start the coding we need to create a model that represents the database then convert it into database design Introduction: You were hired as a consultant to assist in the construction of an efficient database for a non-profit foundation. As a consultant you were able to identify four major entities in the organization system. The entities are Donor, Donation, Events and Projects. You also identified cach cntitics' attributes and functional dependencies as shown below Donor DodgdW (Eustsam LastName. SweetAdd, City, State. ZipCode, Phone, Email) (ZipCods) (City, State) (Email) (Eistane. LesName SpecAdd City, State, ZipCode Phone) (Phone) (Eistlane. LastName. Spectadd. City, State. ZipCode, cmail) Donations Date Events Donors In addition, you had an inserview with the noaprofit organization director to understand more about the database and entity relationships. The director said: "The fundraising or donations can be through donors or through events. One donor can make recurrent donations or one time donation, which means that a donation must have a donor but a donor does not have to donate always. If donations are not cnough an event will be initiated. Usually the collected donation will support one project or several projects, and sometimes we might have a huge project that roquires the collection of donations through several events So a project must be supported by a donation, and donations have to be used for projects City State Email Projects Note: this interview will assist in defining the maximum and minimum cardinalitics (rolationships). Type Name Based on your interview with the Soundation director ereate a data model AND a database design (the data model is different than the database design). The model and the design should represeat the four entities, their attributes, and their relationships. Watch the video lectures related to data model and database design and the difference between the model and the design. Also watch the lecture that will assist you in using MS Visio to develop the model and design. You can use any other software packago including MS Word itself to create your model and your design (does not have to be Visio). You will submit a MS Word Document that has snap shots from MS Visio representing your assignment. Eveats In the design remember to include the data type, data size and the nullnot null constraints. You should spocify which attribute will be used as the primary key and which one will be a foreign key. In addition, you neod to include minimum and maximum cardinalities of thcse relations. Date If you have additional cnquirics about this assignment you can email me or sce me in person during office hours. Assignment Objective: The goal of this assignment is to devclop database modcl and database design that will assist in understanding the relational database. Before we start the coding we need to create a model that represents the database then convert it into database design Introduction: You were hired as a consultant to assist in the construction of an efficient database for a non-profit foundation. As a consultant you were able to identify four major entities in the organization system. The entities are Donor, Donation, Events and Projects. You also identified cach cntitics' attributes and functional dependencies as shown below Donor DodgdW (Eustsam LastName. SweetAdd, City, State. ZipCode, Phone, Email) (ZipCods) (City, State) (Email) (Eistane. LesName SpecAdd City, State, ZipCode Phone) (Phone) (Eistlane. LastName. Spectadd. City, State. ZipCode, cmail) Donations Date Events Donors In addition, you had an inserview with the noaprofit organization director to understand more about the database and entity relationships. The director said: "The fundraising or donations can be through donors or through events. One donor can make recurrent donations or one time donation, which means that a donation must have a donor but a donor does not have to donate always. If donations are not cnough an event will be initiated. Usually the collected donation will support one project or several projects, and sometimes we might have a huge project that roquires the collection of donations through several events So a project must be supported by a donation, and donations have to be used for projects City State Email Projects Note: this interview will assist in defining the maximum and minimum cardinalitics (rolationships). Type Name Based on your interview with the Soundation director ereate a data model AND a database design (the data model is different than the database design). The model and the design should represeat the four entities, their attributes, and their relationships. Watch the video lectures related to data model and database design and the difference between the model and the design. Also watch the lecture that will assist you in using MS Visio to develop the model and design. You can use any other software packago including MS Word itself to create your model and your design (does not have to be Visio). You will submit a MS Word Document that has snap shots from MS Visio representing your assignment. Eveats In the design remember to include the data type, data size and the nullnot null constraints. You should spocify which attribute will be used as the primary key and which one will be a foreign key. In addition, you neod to include minimum and maximum cardinalities of thcse relations. Date If you have additional cnquirics about this assignment you can email me or sce me in person during office hours
