Select any Invoice from a company/service etc. You can search for it online or use one of your company or service providers

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Project — Part 1

10 points

Task: Invoice to Database conversion

NOTE: Complete the project in an Excel document

Can be done as an individual or group (max. of 2 students) project

1. Select any Invoice from a company/service etc. You can search for it online or use one of your company or service providers (handyman, pool service etc). Invoice needs to have at least 4 different fields and at least 3 lines of

item/products data.

2. Attach the .jpeg or screen shot of the Invoice. (1 point)

3. Prepare a database named ‘Invoice’ in ‘raw formJONF’ and add all the tields as columns and fill up the table with given data (line items, name etc.). (1 point)

4. Perform the Normalization process of ¡NF, 2NF, 3NF and normalize the Invoice table. This might lead to creation of other tables too. Normalize them too using same process. Show all your steps in an organized way.

(5 point)

5. Once the tables/entities have been identified — I)raw the E—R model/(ERD) using Visio 2013 and paste a bscrcen shot’ of the ERD. Mark the Primaty Key (PK) (which can also be a composite key - so you mark two primary

keys) and Foreign (FK) if applicable.(3 points)

Attachments:

Expert's Answer

1210 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme