User Account

All Pages

Understanding of the telecommunications industry

Assignment Help Database Management System
Reference no: EM132931344

Database Assignment

SITUATION:
Congratulations on your successful understanding of the telecommunications industry. Brad Simpson is so impressed with your understanding of the telecom industry, he would like you to build a database based on your ERD using Microsoft Access. In addition, Simpson has been storing enterprise data in Excel that he would like you to populate the Access database with. This will help Simpson understand how BNC is performing.

REQUIREMENTS:
A) Create a database using Microsoft Access according to the ERD provided below. Use proper naming for the tables and queries. Also, make sure the data types are correct for all attributes. You may create the database manually or by importing each worksheet from the excel data file.

B) Create the required relationships between tables and be sure to enforce referential integrity. Minimum cardinalities are not important in Access so just ensure that the maximum cardinality of each relationship is correct.

CREATE THE FOLLOWING QUERIES AND NAME THEM
ACCORDINGLY

C) Query C: BNC does not know where they have the most customers. Consequently, they are unable to create target marketing programs to areas where they would like to increase the number of customers. Create a query that lets BNC know the sum of customers they serve in each city.

D) Query D: The company must have a formal safety response plan to meet safety standards. Given rising water levels, BNC is concerned about their nodes near Sylvan Lake. Create a query that will generate a list of nodes associated with the location, Sylvian Lake.

E) Query E: There has been an outage at node Red West 4 and the Chief Marketing Officer would like a list of customers on that node. This will enable her to mail a gift card to the customer's address. Please provide her with a report that lists customer name and address details.

F) Query F: You are investigating the usage patterns of various mobile customers. The Chief Engineer would like to know the total mobile data usage of each customer in 2020 ordered to show the largest mobile data users first. The Chief Engineer is not interested in customer names, simply include the Customer ID to distinguish between customers.

G) Query G: The Chief Marketing Officer is not sure about Satellite TV service in the age of internet streaming. What is the current total monthly revenue for the Satellite TV service?

Please note that the names of query field headings are trivial and should not be changed from the default names when the queries are generated. Please ensure that only the required fields are presented. The query results should be nicely formatted with the appropriate information displayed but unnecessary information hidden.

Attachment:- Database.rar

Reference no: EM132931344

Questions Cloud

Do think that the movement to replace independent : Do you think that the movement to replace independent civil service commissions with executive branch personnel agencies is a good one?
Describe a team-building method : Describe a team-building method that could be applied to each situation. Identify at least two of the common problems that are associated with managing
What are some of the common behaviors that are classified : What are some of the most common behaviors that are classified as primary ways expectations tend to be violated in cross-cultural teams?
Explain the importance of establishing ground rules : Explain the importance of establishing ground rules and respecting cultures amongst team members. How does diversity within members affect
Understanding of the telecommunications industry : Understanding of the telecommunications industry. Brad Simpson is so impressed with your understanding of the telecom industry
How should hrm metrics be used to measure the success : How should HRM metrics be used to measure the success of the HR department's goals related to improving the performance indicators of the entire organization?
Explain emotions collide with cognition : Describe in some detail what this means, and be sure to include the multiple-selves theory as part of your explanation. Provide some examples that exemplify thi
How make sure that future decisions are good ones : How make sure that future decisions are good ones and not an escalation of commitment? Be sure to include a discussion of sunk costs versus future costs
Describe the competitive escalation paradigm : Describe the competitive escalation paradigm and how it can be detrimental to financial decisions. What competitive traps are and how to avoid them.

Reviews

Write a Review

Database Management System Questions & Answers

  Convert an erd to a relational schemacovert the extended

convert an erd to a relational schemacovert the extended entity relationship diagram eerd for orthopedic alliance of

  Describe the movement of enterprise resource planning

Find at least two academic sources that describe the movement of Enterprise resource planning (ERP) activities to the cloud. Discuss the types of ERP activities

  Prepare table which is in first normal form

Prepare the example of table which is in first normal form but not in second normal form and example of a table which is in second normal form but not in third normal form.

  Write a query to display the book number title and subject

Write a query to display the book number, title, subject, author last name, and the number of books written by that author.

  Create one use case diagram containing all of the use cases

Your senior architect has determined that "Create a job." is architecturally significant. Create a fully dressed or detailed use case. She has decided to split.

  Design a database to track the company products

Design a database to track the company's products and orders. Choose either an open-source product or a proprietary product to use, and explain your reasons for choosing it. Identify some of the characteristics of database configuration used in yo..

  Describe the importance of using sub queries in a database

Describe the importance of using sub queries in a database system

  Which group functions can be used on date values

If the "greater than" comparison operator is used with a multiple-row subquery, what type of result will be returned?

  Database management and applications

What errors prevent the table displayed above from being first normal form compliant? Bring the table(s) into first normal form compliance without loss of any data. Identify primary and foreign keys (when present) for all tables.

  Describe the specific steps that you must perform

Describe the specific steps that you must perform in order to appropriately construct the database model. For each step mentioned, speculate the risks.

  Functional dependencies on the relation schema

Do the following functional dependencies hold on the relation schema Student? Justify your answer for each functional dependency

  Why do you expect to see seasonality in sales of shampoo

Why do you expect to see seasonality in sales of shampoo? Why? If the goal is forecasting sales in future months, which of the following steps should be taken?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd