Reference no: EM132359120
ITA#2 : Retail Company-- ERD Development
Marylyn Inc. has experienced tremendous growth over the past one year and top management thinks keeping data in a spreadsheet format has many drawbacks. These include minimizing data redundancy, data inconsistency, and data isolation and maximizing data integrity, security, and independence. Top management has requested you to help the company expand its data capture and reporting capabilities by developing a relational database as a more functional structure.
Requirements:
1. Revisit the Customer Relations Spreadsheet you used in Assignment #1 and determine which tables need to be created.
2. Create the required tables.
3. Transfer the tables to a Microsoft Access Database.
4. Create an Entity Relationship Model using the MS Access Database Management System using the following rules.
a. A customer can place zero or more orders, but an order can be placed by one and only one customer.
b. A product can be requested by one or more orders, and an order can request one or more products.
c. A Sales Representative can serve one or more Customers, but a customer must be served by one and only one Sales Representative.
d. When you have a one to many relationship; place the primary key of the one side of the relationship into the many side of the relationship.
e. When you have a many-to-many relationship; create a bridge table whose composite key has one primary key from each of participating tables.
ITA#3: Database Development
Based on the ER Diagram you developed in ITA#2, you are requested to complete the following assignment:
a. Create a Main Form and Sub-Form for each one to many relationship.
b. Create a query that lists the total purchases by each customer.
c. Create a query that lists the total sales of each Sales Representative.
d. Create a report for the list of total purchases by each customer.
e. Create a report for the list of total sales by each Sales Representative.
f. Export the two reports generated in d. & e. above to an Excel Spreadsheet.
g. Use the knowledge you have gained in class to produce a graph and/or dashboard to present your report to top management. Write your observations on the spreadsheet.
Attachment:- Copy for Assignment.rar
|
Connectivity media-maintenance-tools and troubleshooting
: Prior to beginning work on this interactive assignment read Chapter 3 in the textbook, and review any relevant information in this week's lecture
|
|
Introduced the impact of the global digital divide
: Introduced the impact of the global digital divide. According to the authors, countries that lag behind the rest of the world's ICT capabilities
|
|
Academically reviewed articles on team dynamics
: Review 4 academically reviewed articles on Team Dynamics. Develop power presentation based on the articles. Support your presentation with appropriate reference
|
|
Define process for it system-application recovery procedures
: Explain how to lower RTO with properly documented backup and recovery steps. Define a process for IT system and application recovery procedures.
|
|
Create query that lists the total purchases by each customer
: Create a Main Form and Sub-Form for each one to many relationship. Create a query that lists the total purchases by each customer.
|
|
Analyze technology potential impact on society-business
: Analyze this technology's potential impact on society and business. Make a prediction as to the success of the technology,
|
|
ERM framework and risk governance structure customized
: ITS835 - Design and implement an appropriate ERM framework and risk governance structure customized to any type of organization.
|
|
Direct damage or theft victimless crime
: Is hacking that does no direct damage or theft a victimless crime? Do you think hiring former hackers to enhance security is good idea.
|
|
Conduct social engineering experiments
: While at a restaurant, convenience store, bank, place of business, or any shopping location, ask you waiter or waitress, bartender, server, sales clerk,
|