DataBase using SQL -- 2

The Final Project will contain a database with at least 7 tables. Each table must have a primary key. Foreign keys should be defined where appropriate. 7 User views should be created, normalized to 3rd normal form. Stored procedures will be required for the creation of the database.

A cover page, project description and an Entity Relation diagram for your project will be required.

DB project includes:

1. Title Page (Title, Course Number, Date, and Your Name)

2. Project Description

3. User Views (6-8)

4. Normalization Steps for user views.

5. Combined View or Conceptual Data Model expressed as ER diagram.

6. Atrribute-Domain listing - data types of attributes. This is a 2_D table containing attributes listed in the left column, and the data type on the right column.


Attributes Data type


prodID integer

prodDesc character length 20

unitPrice money

quantOnHand integer

7. Attribute-User View Matrix. This is a 2_D table containing attributes listed in the left column, and Use Views on the top row. If an attribute is used in a user view, an 'X' is placed in the intersection of that row and column.


Attributes User View1 User View2 User View3 User View4 User View5 User View6


prodID x x

prodDesc x x

unitPrice x x

quantOnHand x

custID x x x


assuming that the following is true:

prodID is used in User View1 and User View3

prodDesc is used in User View1 and User View3

unitPrice is used in User View1 and User View5

quantOnHand is used in User View4

custId is used in User View1, User View2 and User View6.

8. Listing of any business rule that may apply to the database.

If there are any rules your database must know about, such as quantity on hand should not be less than 0 and unit price should not be less than 0.0 dollars and not more than 200.00 dollars, etc.

9. Place SQL files that will create the database for this application in a zipped folder with your name: It should contain:

a. [login to view URL] (explaining how to implement this DB)

If you are using foreign key constraints, I would need to know which create sql files to run first, and order of execution becomes important. You need to relate this to me in a read me file, in order that I can easily generate your database.

b. SQL folder containing all the files to implement the DB and run reports to create most or all of the views you created.

c. Label the sql files that creates reports as [login to view URL] so I can identify them quickly.

I want all your sql scripts that create the tables and insert records into the tables, as well as the SELECT statements that will select the attributes for each user view. I plan to generate your database myself and see if your sql create & insert as well as the select query statements give me your user view data. So if you have 6 user views, I should see 6 sql files (the ones you call [login to view URL] for user view1, [login to view URL] for user view2.. etc up to [login to view URL] for user view 3) that will have select statements in them that will generate the data for your views.

Skills: SQL, Database Administration, Database Programming, Database Development

See more: txt file sql 2005 database using aspnet, using sql 2005 database sharepoint services, import csv sql database using dts, design database using fifo method sql, import data sql database using fifo, using sql database vbnet windows mobile example, windowsapplication program using sql database, restore sql database using vb6, create cricket stats database using sql, create oracle database using sql, database using sql hms, access spiceworks database using sql, how to take backup of oracle 11g database using sql developer, how to connect to oracle database using sql developer, identify four basic data manipulations performed on a relational database using sql., connect to remote oracle database using sql developer, how to extract data from database using sql statement, how to take backup of oracle database using sql developer, how to connect to oracle database using sql command line

About the Employer:
( 0 reviews ) Bridgeport, United States

Project ID: #28415248

Awarded to:


**** Requiring that non-key attributes be dependent on "nothing but the key" ensures 3NF. **** Dear, sir. I read your description and slready studied. If you hire me, you'll get a good result in a short time. thanks.

$150 USD in 7 days
(0 Reviews)

12 freelancers are bidding on average $115 for this job


Need talk with customer to discuss Need talk with customer to discuss Need talk with customer to discuss

$100 USD in 7 days
(17 Reviews)

Hello Dear...! Alert: I will give you 20% discount on my bid rate also give on my All Services. So grabs this special offer is limited. Let’s get to the point. I came to know that your Looking a developer which hav More

$50 USD in 1 day
(17 Reviews)

I can implement described project in a most qualitative way. I am highly qualified database developer with more than 10 years length of time worked and with advanced skills in professional database design and developme More

$280 USD in 5 days
(25 Reviews)

Hello employer, I would like to bid for your project work pertaining to database and SQL Here is my linkedin profile: [login to view URL] I am data engineer and working in area of da More

$300 USD in 7 days
(8 Reviews)

Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Burs More

$99 USD in 1 day
(13 Reviews)

Hello! ★★★★★ The Best DataBase Developer ★★★★★ I read your job description carefully and I understand what you want. I'm a Professional DB Developer with 6+ years of experience and will strongly assist you well for t More

$50 USD in 1 day
(1 Review)

Hello I am a software engineer working for almost twenty years. I have vast experience sql, oracle, mysql, postgresql, database programming. I have also theoretical and practical knowledge on Database Application Desig More

$100 USD in 6 days
(2 Reviews)

Hello, I am a proficient academic and technical writer. I am also an expert in system analysis and design, system architecture and business information systems design. I will create the UML diagrams for any given case. More

$100 USD in 3 days
(2 Reviews)

## Experienced In Database Management System## Hi dear sir/madam, I have completed B.Sc.(Engg.) and M.Sc.(Engg.) in Computer Science & Engineering. I am expert in Database Management System. I have vast knowledge in More

$50 USD in 1 day
(1 Review)

I am PhD scholar of computer science and professional database designer and developer and master of SQL I study your project and hopefully confident one that I can do it

$56 USD in 1 day
(1 Review)

Hello, I coul help you eith this task. I have several databases for you. So I will provide to you all Scripts DDL, DML for your project. Can we chat for getting more detail about?

$50 USD in 2 days
(0 Reviews)