Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started