Database Analysis and Design:

Implement the initial database design for the Customer Relationship Management VIEW as described below in your selected RDBMS. You need to create the Entity-Relationship model from your normalization and Database analysis, define tables, primary keys, foreign keys, create additional descriptive fields (at least 2 for each entity - relationship tables do NOT need additional fields in all cases), and any attribute value constraints you deem necessary. Create the VIEW and populate the tables to duplicate the following:

 

You will be evaluated on:
1. The Feasibility, Flexibility, and Appropriateness of the Normalization and Relationships you create between entities, including indication of the type of relationship

Submit your Entity-Relationship Diagram generated by the DBMS in file named:
lastname.firstname.Project 02 ERD.jpg (or png or pdf or gif)

2. Definition of the VIEW, including the conditions for data population into the normalized data tables
Please run a SELECT *FROM ; saving the results in a notepad (text) file with the extension .dat, and submit your file(s) using your last name as part of the file name in the following format:
lastname.firstname.Project 02 view.dat

3. Data Population for each table supplying the view and your additional descriptive fields
Please run a SELECT *FROM

; for each table, saving the results in a notepad (text) file with the extension .dat, and submit your file(s) using your last name as part of the file name in the following format:
lastname.firstname.Project 02 tables.dat

4. The Attributes and KEY fields you identify for each entity

5. Value Constraints you define for fields you select
Please save all of your EXPORT DATABASE CREATE code in a notepad (text) file with the extension .sql , and submit your file(s) using your last name as part of the file name in the following format:
lastnametirstname.Project 02 create.sql

6. Supply the SQL and result for the following action:
INSERT a new Customer and Contact record INTO THE VIEW for ServiceRep = "ITDB" where the Customer is "SPRING 2014" and the Contact person is your name. (20 points)

Please save all of your INSERT SQL code in a notepad (text) file with the extension .sql, and submit your file(s) using your last name as part of the file name in the following format:
lastnametirstname.Project 02 Insert.sql

Please run a SELECT *FROM

; for each table, saving the results in a notepad (text) file with the extension .dat , and submit your file(s) using your last name as part of the file name in the following format:
lastnametirstname.Project 02 tables after update.dat

Complete the following tasksin microsoft access create the Complete the following tasks: In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables. Write SQL statement ...

Purpose of the assessment with ulo mapping the purpose of Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop skills in managing data in databases and to gain understanding of data model development and implementation using a commercially a ...

Continuing the project you have worked on in weeks 1-4 in Continuing the project you have worked on in Weeks 1-4, in this final week, complete the following tasks: Refine your database and SQL statements by incorporating your instructor's feedback. Verify that the database comp ...

For this assignment you will be provided a database backup For this assignment, you will be provided a database backup for a database called FinanceDB. You will have to restore this backup to your own version of SQL Server. All of the questions in this assignment relate to the F ...

Assignment - queries functions and triggersaimthe aims of Assignment - Queries, Functions and Triggers Aim The aims of this assignment are to: formulate SQL queries; populate an RDBMS with a real dataset, and analyse the data; design test data for testing SQL queries; create SQ ...