Information I have:

Background Information for the Database Development

Pipefitters Supply Company accepts orders over different media. When an order arrives, one of the salespersons enters it as a sales order. The sales order includes the customer’s name and a list of the inventory items that the customer wishes to purchase. This inventory list includes the quantity of each inventory item and the price at which Pipefitters is currently selling the item. When the order is ready to ship, Pipefitters completes an invoice and records the sale. Sometimes, some of the inventory items a customer has ordered are not in stock. In those cases, Pipefitters will ship partial orders. Customers are expected to pay their invoices within 30 days. Most customers do pay on time; however, some customers make partial payments over two or more months. Each customer may have many sales orders, many sales, and many cash receipts. Sales orders and sales can each have many inventory items, and each inventory item can appear on many sales orders and many sales.

Tables of the database:

·        Customer Table

·        Order Table

·        Invoice table

·        Salesperson Table

·        Item Table

·        Payment Table

Explanation:

ER Diagram:

Relationship:

·        Many to many relationship between the table customer and the order.

·        Many to many relationship between the table order and the item.

·        Many to many relationship between the table salesperson and the item.

·        Many to many relationship between the table invoice and the customer.

·        Many to many relationship between the table invoice and the order.

·        Many to many relationship between the table invoice and the salesperson

·        Many to many relationship between the table invoice and the payment.

·        Many to many relationship between the table customer and the payment.

Content of the table:

Table: Customer:

Table: Order:

Table:Salesperson:

Table: Invoice:

Table: Payment:

Table: Item:

Description:

·        C_ID used as a primary key in the table Customer. It is used to show the unique ID of each party.

·        O_ID used as a primary key in the table Order. It is used to show the unique ID of each order.

·        I_ID used as a primary key in the table invoice. It is used to show the unique ID of each invoice.

·        P_ID used as a primary key in the table Payment. It is used to show the unique ID of each payment.

·        Item_ID used as a primary key in the table Item. It is used to show the unique ID of each item.

·        S_ID used as a primary key in the table Salesperson. It is used to show the unique ID of each sales man.

·        The C_ID is a foreign key in the table Order. It is used to fetch the details of the customer.

·        The Item_ID is a foreign key in the table Order. It is used to fetch the details of the item.

·        The C_ID is a foreign key in the table Invoice. It is used to fetch the details of the customer.

·        The O_ID is a foreign key in the table Invoice. It is used to fetch the details of the order.

·        The S_ID is a foreign key in the table Invoice. It is used to fetch the details of the salesperson.

·        The C_ID is a foreign key in the table payment. It is used to fetch the details of the customer.

·        The I_ID is a foreign key in the table payment. It is used to fetch the details of the invoice.

·        The S_ID is a foreign key in the table item. It is used to fetch the details of the salesperson.

What I need to do (And I need the file):

1)     Use Microsoft Access to create associated tables

2)     Link all tables by Microsoft Access’s relationship tool

3)     Copy the relationship of your databased shown in Microsoft Access to a word document

4)     Write a report in about 300 words to address

a.      What are frustrations for you to create a small database?

b.     Can you image the usage of database design in your career development?

c.      Do you consider using a small database to organize the data you collected for your course project? Why or why not?

d.     What are your suggestions for improving this Assignment? 

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4
• Attachment 5
• Attachment 6
• Attachment 7

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Information Literacy ActivityPoints: 15 Given the following sample research question, plan and execute a search for relevant information resources. Research statement: I want to investigate how the practice of blogging has influenced high school education. 1. Identify the main concepts in your search statement or research question. List the concepts here; these will become keywords that you will use when you search for information in a database.Concepts that make up my search statement: 2. Think of synonyms for each of your concepts. What other words might you use to search for relevant information? Concept 1: Concept 1 Synonyms: Concept 2: Concept 2 Synonyms: 3. Using the Boolean operators AND, OR, and NOT, construct a search statement that includes the various concepts and synonyms. 4. For this exercise, use the database called ProQuest Research Library. This database covers a wide variety of topics from many different fields.Where do you go to get access to ProQuest? List the steps you took or Web pages you visited to find ProQuest. 5. Using truncation allows you to find all forms of a word, when the beginning letters are the same, as in the words “blogs”, “bloggers”, “blogging”, and “blogosphere”.5a. What is the truncation symbol in ProQuest? Check the Search Tips if you’re not sure. 5b. Using the truncation symbol, what could you search for in ProQuest that would find results containing any of the following terms: “blogs”, “bloggers”, “blogging”, and “blogosphere”? 6. There might be articles in the database that use the term “blog” and others that use the term “weblog.” How can we use Boolean operators in a search to find articles that include either term (but not necessarily both terms in the same article)? 7. Perform a search in ProQuest that will return articles related to blogging. What search term(s) did you use?8. How many results were returned?9. Since we are looking for articles related to blogging in the field of education, refine your search by adding “AND education” to your search. How many results were returned with “AND education” added to your previous search?10. If you search for “weblogs and education” you will get several hundred results. Look at the section of the results screen marked “Suggested Topics” and you will see several items listed there. One link listed there is “Weblogs AND Education.” Clicking this link will perform a Subject search on those terms, rather than a more general keyword search. Subject searches are more specific than keyword searches, but you have to use the database’s preferred terms (such as “weblogs” instead of “blogs”). How many results do you get if you click “Weblogs AND Education” under Suggested Topics? 11. ProQuest allows you to narrow your search even further to show only articles that come from scholarly journals. Click the Scholarly Journals tab to limit the results in this way. How many results are now displayed? 12. Once you have narrowed the list of results down to a manageable number (say, less than 50), you should start scanning the results to find potential articles for your research. Examine the list of results and provide complete citations for two of the articles in your results list that might be useful for this example topic. 13. One of the articles on the results list is an article called “Web 2.0: New Tools for Distance Learning” by Christopher Essex. View this article. In the References section of Essex’s article, there is a citation for an article called “Scholars Who Blog” by D. Glenn. Is the article by Glenn available through ProQuest? 14. Describe the steps you took to determine whether the Glenn article is available through ProQuest.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Information management systems include email, hard copy, voice mail, videoconferencing and websites. true or false ?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

INFORMATION MANAGEMENTWhen the output of some units can be used as inputs to other units, or if twoorganizations pool markets and expertise that result in lower costs and generateprofi ts it is often referred to as creating:a. value webs.b. value chains.c. synergies.d. core competencies.

When the output of some units can be used as inputs to other units, or if twoorganizations pool markets and expertise that result in lower costs and generateprofi ts it is often referred to as…

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Information on the relation to US history and Oakwood Cemetery in Troy, NY between roughly 15,000 B.C. to 1877 (the end of Reconstruction). 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"