Category | Assignment | Subject | Computer Science |
---|---|---|---|
University | Concordia University | Module Title | COMP353 Department of Computer Science and Software Engineering |
Assessment Type | Assignment 2 |
---|---|
Academic Year | 2025 |
A Non-Profit Local Organization called NPLO that is concerned with the welfare of poor people in your community would like you to design a database to represent all the data that they need to store for their operations. The following are the requirements specified by the company:
NPLO accepts donations from people. Donations could be either money or products. Employees of NPLO process the donated products and sell them to the local people who are interested in them. Part of the donations are used to cover the expenses to run the organization, and the rest is used to help poor people in the community. The database contains information about Donors, Donations, Products, Sales, SalesItems, Employees, Expenses, Categories of donated items, and Donor Interests..
Member is the relation that holds information about people known to the application. Every member has an ID, first-name, last-name, middle-initial, date-of-birth, address, gender, phone- number, email-address, social-security-number, and start date of membership. A member could be either a donor, a client, or an employee.
Donations is the relation that holds information about each donation. Every donation has an ID, the donor ID, date of the donation, type of donation, and amount of donation.
Products is the relation that holds information about every item donated. Every product has an ID, the description of the product, the category of the product, the donation date of the product, the selling price of the product, the weight (in Kilogram) of the product, and a flag indicating whether the product is in stock or has been sold.
Sales is the relation that holds the information about the items sold. Every sale has an ID, date of the sale, amount of the sale, total weight (in kilogram) of the sale, and the delivery fee if the sale is to be delivered.
SalesItems is the relation that holds the information about the items sold for every sale.
Categories is the relation that holds information about the category of the items donated. Every category has a category ID, and a description of the category. Every donated item belongs to only one category. Many donated items can belong to the same category.
DonorInterests is the relation that holds information about the interests of every donor to the organization. A donor can have an interest in zero, one or many categories.
Employees is the relation that holds the information about every employee working for the organization. In addition to the properties of Persons, every employee has a job-title (president, vice-president, cashier, other), salary. If the salary is zero or null means that the employee is a volunteer.
Expenses is the relation that holds the information about all the expenses paid by the organization. Every expense has an ID, the ID of the president who approved the expense, the date of the payment of the expense, the amount of the expense, the type of the expense, and the description of the expense. The type could be either rent, bill payment, or charity payment. Only president of the organization can approve an expense.
Some information about how this organization runs:
Do You Need COMP353 Assignment 2 of This Question
Request to Buy AnswerThese are the minimum requirements for your application. You may need to add additional entities and attributes to meet the requirements for the queries in Part II.
With this information, do the following initial steps in your database design process:
Express the following queries in SQL: ( Your queries should work with any valid database instance.)
Achieve Higher Grades COMP353 Assignment 2 & Raise Your Grades
Order Non Plagiarized AssignmentStruggling with your COMP353 Department of Computer Science and Software Engineering Assignment 2? Let us help! We offer professional, affordable assignment writing services that are AI-free, plagiarism-free, and delivered on time. Our team of PhD experts understands what universities expect and creates high-quality content tailored to your needs. We also offer free assignment samples so you can check our quality before booking. Our expert team provides Computer Science Assignment Help that has been designed for the students. We’re available 24/7 to support you. Don’t wait until the last minute—contact us now and make your academic life easier with trusted expert assignment help!
Let's Book Your Work with Our Expert and Get High-Quality Content