Database Fundamentals

Anonymous
timer Asked: Oct 21st, 2018
account_balance_wallet $9.99

Question Description


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

Unformatted Attachment Preview

Part 2 – Written Analysis CSCI 1320 Database Fundamentals 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 Shire Goodyear Tierney FirstName Robert Katherine Doris InvoiceDate 12/14/2012 12/10/2012 12/23/2012 InvoiceItem Antique Desk Dining Table Book Shelf Quantity 1 1 1 Price 3000 1000 250 Tax 249 83 20.75 Total 3249 1083 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 ...
Purchase answer to see full attachment

Tutor Answer

ProfDwayne01
School: Carnegie Mellon University

Hello please edit the footer to include you nameThank you for your time

Running head: DATABASE FUNDAMENTALS

Database Fundamentals
Student’s Name
CSCI 1320 Database Fundamentals
October 21, 2018

1

DATABASE FUNDAMENTALS
1. Table needed
Depending to the store’s operation, the following are some of the tables that might be
required.
i.

Customer table – Required to keep the customer’s information

ii.

Items Tables – This records the stores’ items

iii.

Invoice tabl...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors