SQL Server 2005 Project(for Y.J.W.)

Cancelled

Database Project A. Requirements Analysis Problem: Create a database to help a User sell used vinyl records. Information Needs of Owner 1.) Add Inventory for sale - Needs database to store all information related to each item (Album title, Artist, Label, Medium, Genre, country released in, release date) 2.) Needs to track condition of each used item and it’s price (Cover/Sleeve condition, Vinyl/Media Condition, Price) 3.) Needs to track location of each item in the store (Bin/Box location) 4.) Needs to track shipping costs, weights and type by country to insure proper shipping costs are applied to each order 5.) Track customers and orders to know what customers have purchased in the past ??" let them know if you have similar items for sale that they may have missed. 6.) An easy to use search function which will locate what user is looking for by using Title, Artist, Genre B. Conceptual Design ??" Entity-Relationship diagram ??" see Excel Spreadsheet Relationships ??" Excel Spreadsheet C. Physical Design - Create tables and columns from entities and attributes of your ER Diagram: ??" Excel Spreadsheet SQL create table statements for all tables, keys and referential integrity: Excel Spreadsheet. D. Implementation ??" Will use Microsoft Sequel Server 2005 for the database. Use Microsoft Visual Studio 2005 for the interface. The interface would be in Visual C#.Net 2005 and include the following: 1.) A login page. a.) Admin login will take you to Products details of add/modify and delete. b.) Customer login will take you to Customer details of add/modify products in the shopping cart - used datagrids. E. For the triggers listed in the requirements I would like three: One that would delete a record in the ALBUM table after it was shipped. The second would calculate “OrderTotal?? after shipping costs were inserted in the SHIPPINGCOST table. A third would calculate OrderSubtotal based on the number of records purchased.

## Deliverables

Attached the conceptual and physical design of database, and some SQL code which may need to be fixed

Skills: C# Programming, Engineering, Microsoft, MySQL, PHP, Project Management, Software Architecture, Software Testing, SQL, Windows Desktop

See more: what are problem statements, sql price, sql create table price, problem statements, price table user interface, price of design label, price label design, microsoft sql server price, insure one, design your album cover, design label price, design for album cover, design an album cover, create on page for products, cover page for album, b j's, album sleeve design, album cover search, album cover page, 5/y-5, what is microsoft visual, what is microsoft project, visual studio excel, SQL Server Admin, server studio

Project ID: #3435398

9 freelancers are bidding on average $497 for this job

ghareebvw

See private message.

$255 USD in 2 days
(9 Reviews)
3.0
tuanna711

See private message.

$127.5 USD in 2 days
(6 Reviews)
2.0
yjw

See private message.

$42.5 USD in 2 days
(1 Review)
0.5
felipelorenzo

See private message.

$51 USD in 2 days
(0 Reviews)
0.0
humbertomartinez

See private message.

$170 USD in 2 days
(0 Reviews)
0.0
Verytion

See private message.

$127.5 USD in 2 days
(4 Reviews)
2.0
setrambhardwaj

See private message.

$297.5 USD in 2 days
(1 Review)
0.0
daciansoft

See private message.

$1700 USD in 2 days
(0 Reviews)
0.0
johnnyboy1st1

See private message.

$1700 USD in 2 days
(1 Review)
0.0