Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want you to do a project about a BANK in database . 1-add a 15 questions about the problems 2- add a cover page

I want you to do a project about a BANK in database . 1-add a 15 questions about the problems 2- add a cover page about what is in the project about. 3- add the schema which contains the attributes and specify them into simple , composite and multi-valued

image text in transcribed

Project reports should have the following sections: 1. Preliminary Pages. 2. Body of Report. 3. Bibliography/ References. 4. Appendices (if any). 1. Preliminary Pages. Each part below should on a separate page(s). Page title The title page must be in the accepted standardized form. Table of contents Font size 14. List/s of tables and figures All your tables and figures must be included in these lists. List's are not numbered. 2. Body of Report All reports contain at least the following (or equivalent) sections: Introduction Data requirements. For example, part of the data requirements for a video store application might be as follows: Each branch has staff, which includes a manager. The details held on manager are his/her name, position and salary. Each member of the staff is given a staff number, which is unique through out the company. Each branch is allocated a stock of videos, the details on videos are catalog number... User transactions 1 Example user transactions: i. Enter/ update delete the details of a given branch 2. List the details of branches in a given city. 3. Conceptual model: complete Entity - Relationship (ER) diagram including specification of relationship cardinality and multiplicity and participation constraints. Mapping the ER diagram to the relational database schema. Database tables: create table structures based on the relational schema Normalization: All the tables should be in the BCNF normal form. SQL DDL statements: for creating tables with the above mentioned specifications and integrity constraints. . Conclusion 3. Bibliography/Reference. Project reports should have the following sections: 1. Preliminary Pages. 2. Body of Report. 3. Bibliography/ References. 4. Appendices (if any). 1. Preliminary Pages. Each part below should on a separate page(s). Page title The title page must be in the accepted standardized form. Table of contents Font size 14. List/s of tables and figures All your tables and figures must be included in these lists. List's are not numbered. 2. Body of Report All reports contain at least the following (or equivalent) sections: Introduction Data requirements. For example, part of the data requirements for a video store application might be as follows: Each branch has staff, which includes a manager. The details held on manager are his/her name, position and salary. Each member of the staff is given a staff number, which is unique through out the company. Each branch is allocated a stock of videos, the details on videos are catalog number... User transactions 1 Example user transactions: i. Enter/ update delete the details of a given branch 2. List the details of branches in a given city. 3. Conceptual model: complete Entity - Relationship (ER) diagram including specification of relationship cardinality and multiplicity and participation constraints. Mapping the ER diagram to the relational database schema. Database tables: create table structures based on the relational schema Normalization: All the tables should be in the BCNF normal form. SQL DDL statements: for creating tables with the above mentioned specifications and integrity constraints. . Conclusion 3. Bibliography/Reference

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MySQL/PHP Database Applications

Authors: Jay Greenspan, Brad Bulger

1st Edition

ISBN: 978-0764535376

More Books

Students also viewed these Databases questions

Question

2. Explain grades or test results.

Answered: 1 week ago

Question

socialist egalitarianism which resulted in wage levelling;

Answered: 1 week ago

Question

soyuznye (all-Union, controlling enterprises directly from Moscow);

Answered: 1 week ago