database fundamentals 2

Stuck with a difficult assignment? No time to get your paper done? Feeling confused? If you’re looking for reliable and timely help for assignments, you’ve come to the right place. We promise 100% original, plagiarism-free papers custom-written for you. Yes, we write every assignment from scratch and it’s solely custom-made for you.


Order a Similar Paper Order a Different Paper


Part 2 – Written Analysis
CSCI 1320 Database Fundamentals

This assignment can be completed in 1 to 2 pages the attachment is just an extra copy.

You have been assigned to a new development team.A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future.

You received an email from the client with the list shown below.Currently, this list tracks their daily business.To prepare for the meeting with the client, you develop a first draft prototype of a relational database.

In your one page MS Word pdf report include the following:

1. Table(s) needed.Hint:Think of the table’s purpose.

2 Fields for each table (list ‘primary key field’ first).

3. Add a page footer with your full name, date prepared, and filename

4.Name at least 7 additional fields (in addition to those listed in table below).

5.Which field or fields shown below do not belong in a table?Explain why.

6.Identify the primary key for each table by underlining.

7.Draw an E-R diagram showing relationships between tables.

For the E-R diagram you can use Crow’s Feet symbols or join line between tables at the field level (primary key to foreign key).

You choose the method of how to show these relationships. Some options include: hand drawn with a picture of it inserted into a document, MS Access, or graphics software.

8.Develop 3 questions to ask client at your face-to-face meeting next week that will assist in refining the prototype’s design.

LastName

FirstName

InvoiceDate

InvoiceItem

Quantity

Price

Tax

Total

Shire

Robert

12/14/2012

Antique Desk

1

3000

249

3249

Goodyear

Katherine

12/10/2012

Dining Table

1

1000

83

1083

Tierney

Doris

12/23/2012

Book Shelf

1

250

20.75

270.75

Anderson

Donna

12/22/2012

Desk Lamp

1

45

3.74

48.74

Shire

Robert

12/14/2012

Antique Chair

2

125

20.75

270.75

Writerbay.net

We’ve proficient writers who can handle both short and long papers, be they academic or non-academic papers, on topics ranging from soup to nuts (both literally and as the saying goes, if you know what we mean). We know how much you care about your grades and academic success. That's why we ensure the highest quality for your assignment. We're ready to help you even in the most critical situation. We're the perfect solution for all your writing needs.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper