Annual Report
FY [Year] [Add a quote here from one of your company executives or use this space for a brief summary of the document content.]
|
Fundamental of Databases
IT403 |
Instructions: |
· You must submit two separate copies (one Word file and one PDF file) using this Template on Blackboard via the allocated folder. These files must not be in compressed format.
· It is your responsibility to check and make sure that you have uploaded both the correct files. · Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets or languages other than English or any kind of manipulation). · Email submission will not be accepted. · You are advised to make your work clear and well-presented. This includes filling your information on the cover page. · You must use this template, failing which will result in zero mark. · You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question. · Late submission will result in ZERO mark. · The work should be your own, copying from students or other resources will result in ZERO mark. · Use Times New Roman font for all your answers. |
|
|
Database System for a Blood Bank Organization
This project is about designing a database system for a Blood Bank Organization. In this system, donors can donate blood many numbers of times. The donated bloods are stored at clinics at different locations. Each clinic is administered by a specific employee.
The data requirements are characterized as follows:
Note: You can make any additional reasonable assumptions for any missing details for this system.
2.5 Marks |
Learning Outcome(s):
LO 5 Develop a data model for a business application.
|
Design an Entity-Relationship diagram for the database of Blood Bank Organization.
2.5 Marks |
Learning Outcome(s):
LO 4 Design a database for a business application.
|
Convert your ERD into relational schemas and then apply normalization rules (1NF, 2NF, 3NF, BCNF, and 4NF) against these relational schemas.
2.5 Marks |
Q
Learning Outcome(s):
LO 6 Create a database application to store and retrieve data.
|
uestion three
Write All SQL statements for:
Using any database (MySQL, Oracle…, etc.) and include screenshots
2.5 Marks |
Learning Outcome(s):
LO 4 Use Structured Query Language to perform queries and to perform relational operations.
|
Question fur
Write SQL Queries for the following:
Include screenshots to show all the queries statement and results for the above.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more