Implement the initial database design for the customer

Question

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

View Complete Question

Request for Solution File

Ask an Expert for Answer!!

PL-SQL Programming: Implement the initial database design for the customer

Reference No:- TGS0978930

Expected delivery within 24 Hours

Have a Question? (oR Write a Review)

Write atleast 100 words!!

   Recent Questions Asked PL-SQL Programming

Q : Slaves filled many roles within the slave system compare american historyslaves filled many roles within the slave system compare and contrast the roles played and lives led by

Q : Using the waters bottling companyin module 1 continue to using the waters bottling companyin module 1 continue to build the marketing plan sections for the product you have

Q : Question 1 what is a functional strategy question 2 discuss question 1 what is a functional strategyquestion 2 discuss the more popular stability strategiesquestion 3 what is

Q : The global harmonization system of classification and the global harmonization system of classification and labeling of chemical substances ghs has been adopted by the

Q : Implement the initial database design for the customer database analysis and designimplement the initial database design for the customer relationship management view as

Q : How did thomas jefferson and john adams divide over the how did thomas jefferson and john adams divide over the french

Q : Qestion 1 of 17 ltxmlnamespace prefix o ns question 1 of 17 ltxmlnamespace prefix o ns urnschemas-microsoft-comofficeoffice gtat a six sigma quality level if

Q : Create the executive summary portion of the marketing case study the information in the case study is used each week when writing the individual sections of the marketing

Q : Suppose 25 urine samples need to be tested per minute what suppose 25 urine samples need to be tested per minute what is the smallest batch size in samples that ensures that the