Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) Objective of this project is to develop complete data centric application.

Outcomes

After completing this project, students are expected to:

i) Analyzing System Requirement

ii) Representing the requirements into logical design using Entity Relationship (ER) or/and Enhanced Entity Relationship (EER) model

iii) Mapping designed model into relational schemas

iv) Transforming the relational schemas into normalized tables. Normalizing above relational schema into BCNF

v) Writing SQL statements

a) Creating tables including all applied integrity constraints

b) Populating all the tables with sample records.

vi) Developing user interfaces for using the system

Title Page

The title page must include Project Title, Authors

Contents

1. Introduction

2. Current System (if any)

3. Stakeholders

4. Key Problems

5. System Functional Requirements

6. Work Plan

Phase I: DB Requirements and Conceptual Design (ER/EER model)

Using EER model develop conceptual model (ER or EER diagram and other specific requirements like list of users, performance requirements if any, etc.) for the problem.

Completing this document can be done in many flexible ways; following items must be part of the document:

1. Introduction:

Introduction of problem (include from you problem description/project proposal)

2. Database Requirements (defines the entities, attributes, entity relationships and business rules (if any))

3. EER Model:

A conceptual model of data requirements using standard notations as well as Logical Model developed using TOAD data modeller.

4. List of users (within the stakeholders list provided in project proposal)

5. Sample queries (Five to ten Queries) – highlighting system capabilities in terms of information retrieval in simple English not the SQL queries

6. List of required reports

List here titles and purpose of different reports produced from the database

The ER diagram should models the problem statement.

Phase II: Logical/Physical Design  and Back End Implementation

A)  Relational Model (Logical and Physical Schema Development)         

B)  Server (back-end) implementation

Conceptual model developed in phase 2 will be transformed into logical schema using the relational data model. The outcome of this transformation will be a relational schema. The schema developed in phase 2 will be implemented. Oracle or any other relational database management system can be used for this purpose. The schema should have the following components:

1. Set of required relations

2. All the integrity constraints

3. View of each user (if applicable)

4. Suggested file structure for each relation

5. All the tables properly defined /created

6. All constraints properly defined

7. For each table few instances of data should be entered.

A report must consist the following:

1. Problem statement (taken from project proposal)

2. ER diagram, (taken from phase I document)

3. Relational schema (all relations and constraints),

4. List of Users, (taken from phase I document)

5. View of each user, and

6. Physical (or internal) schema, i.e., file structure for each relation

7. Physical ER Model generated from Logical model submitted in phase I document using TOAD data modeller.

8. DDL script /SQL statements used to create database objects

9. DML insert statements to insert the data in to tables.

Phase III: User Interface (Front-end) Implementation and Project Presentation

The team will develop the forms and reports to be served as front-end of the system using MS Access. The developed system will be tested and a progressive/ Incremental final report for the system will be prepared. The report must contain the material from all previous phases along with the user documentation. A tentative contents list could be as following:

1. Introduction (from project proposal)

2. The problem statement (from project proposal)

3. Conceptual Design / model (ER/ EER diagram) (from phase I document)

4. Relational schema (from phase II document)

5. Physical Design (from phase II document)

6. The user manual (You can add snapshots of your screens along with explanations about how to use for users.)

7. The conclusions (your own experiences)

8. Distribution of Project tasks ( A table showing who did what)

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M95518

Have any Question? 


Related Questions in DBMS

Apriori analysis and cluster analysis-data analysis

ApriorI analysis and Cluster analysis-Data Analysis assignment CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" se ...

Here is two assignment one is only summery of project from

Here is two assignment one is only summery of project from first assignment, in powerpoint. pleasedont copy and paste, it will be verified by software for plagiarism. please cite all sources by APA format. due date is 26 ...

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

Discussionatleast 1 paragraph for each partpart 1 remote

Discussion Atleast 1 paragraph for each part Part 1: "Remote Access" Please respond to the following: • Remote access to corporate resources is becoming commonplace. From an auditing perspective, suggest two or more cont ...

Suppose that you are the database developer for a local

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training s ...

Project database and programming designthis assignment

Project: Database and Programming Design This assignment consists of two sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this a ...

1 analyse situations andor environments for the application

1) Analyse situations and/or environments for the application of database solutions including web connectivity 2) Create, alter and remove relational tables, indexes and data using an appropriate database language. 3) Ex ...

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Graph databases assignment1choose a social network that you

Graph Databases Assignment 1. Choose a social network that you use. Say, FaceBook, Twitter, LinkedIn, or anything else. 2. Design a model to store and manage relationship data from these social networks in a graph databa ...

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro