Description
BIAM 530 Full Course DeVry
BIAM 530 Developing and Managing Databases for Business Intelligence
BIAM 530 Week 1 Database Systems and Data Models
BIAM 530 Week 1 Discussions
DQ 1 COLLEGE TOWN UNIVERSITY DATABASE & DBMS BUSINESS APPLICATIONS
- College Town University (CTU) is a small university on the banks of the Purple River. The university has a student population of about 2,500 full-time students. Students can major in five different areas (Fine Arts, Science, Math, Business, and Technology) at CTU. Each semester, there are 100 courses offered. CTU wants to computerize their courses and student records. You have been hired as a consultant to work with the president and the chief technology officer (CTO) of CTU to design a database for the system. What entities would you suggest, and what are some attributes that should be included for each entity?
- You are the CIO of your organization. Explain to the board of directors what type of data management system you would recommend and why you would recommend it.
DQ 2 WORKOUT ROOM (SIGNATURE ASSIGNMENT)
You will be completing a Signature Assignment in Week 3. The Week 3 Lab (the Signature Assignment) aligns with Outcomes C, D, and E. The Lab provides an existing business (Sample) database. SQL DML will be used to manage the database and extract data to answer business questions. The results will be reported and analyzed with a description provided. These activities are common activities that take place in businesses on a daily basis.
These common activities can be broken down into steps:
- Gather/obtain business requirements
- Use SQL with DML and manage the data in the database
- Describe and analyze query results
- Create a report on the data results
Review the Signature Assignment Overview page in the Introduction & Resources module.
Our focus for this discussion will be numbers 3 and 4, to help you prepare for the Week 3 Signature Assignment Lab.
What is the best way to analyze data and how should it then be reported? What would be your recommendations for using text, charts, etc.?
BIAM 530 Week 1 Homework
Complete the problems at the end of Chapter 1: Problems 1–10.
Complete the problems at the end of Chapter 2: Problems 1–6.
Submit your numbered answers to all problems in a single Microsoft Word document. Some of these problems require you to draw entity relationship diagrams (ERDs), or class diagrams. For this assignment, you may sketch these diagrams by hand and insert a photo or scanned image of your sketch in your Word document. Make sure your sketches are legible in the document. If you choose, you may also create these diagrams using the drawing tools in MS Word, or create the diagrams in MS Visio or another application and copy and paste them into your Word document. You will learn more about using MS Visio to create these diagrams in Week 2. Please follow the 80/20 Rule for all written assignments: 80% or more of the work is in your own words and 20% or less is in the words of another author.
Submit your assignment.
Rubric
Criteria | Ratings | Pts | |
---|---|---|---|
Ch.1 Prob. 1 |
|||
Ch.1 Prob. 2 |
|||
Ch.1 Prob. 3 |
|||
Ch.1 Prob. 4 |
|||
Ch.1 Prob. 5 |
|||
Ch.1 Prob. 6 |
|||
Ch.1 Prob. 7 |
|||
Ch.1 Prob. 8 |
|||
Ch.1 Prob. 9 |
|||
Ch.1 Prob. 10 |
|||
Ch.2 Prob. 1 |
|||
Ch.2 Prob. 2 |
|||
Ch.2 Prob. 3 |
|||
Ch.2 Prob. 4 |
|||
Ch.2 Prob. 5 |
|||
Ch.2 Prob. 6 |
|||
Total Points: 80.0
|
BIAM 530 Week 2 Database Design
BIAM 530 Week 2 Discussions
DQ 1 DATABASE DESIGN FOR A GOLF DISTRIBUTOR & UNDERSTANDING AN ENTITY RELATIONSHIP DIAGRAM (ERD)
- You have been asked to create the logical data model for the Golden Eagle Wholesale Golf Distributors. Golden Eagle distributes golf equipment for various manufacturers to the pro shops at golf courses throughout the state. They store the equipment in a centrally located warehouse and ship to the pro shops based on the purchase orders submitted by their sales staff or ones that are phoned in directly by their customers. Each sales rep is assigned to golf courses within a specific area of the state. What entities, attributes, and relationships would you include in the data model for this organization?
- You have created an entity relationship diagram (ERD) for an organization’s database, and you are preparing to review it with the company’s managers to make sure it is complete and correct. The managers do not have technical backgrounds and are unfamiliar with database design. How would you explain the concept of an ERD to these managers to orient them for your review?
DQ 2 WORKOUT ROOM
Please share your expertise on this Week’s Lab Assignment. Give examples or discuss topics you might consider using and help a classmate. Please post two (2) times throughout the week. (On two different days.)
BIAM 530 Week 2 Lab Relationships and Normalization
BIAM 530 Week 3 Structured Query Language (SQL)
BIAM 530 Week 3 Discussions
DQ 1 WORKING WITH DATABASE OBJECTS & MANIPULATING DATA IN THE DATABASE
- Review the Tiny College case concerning the Free Access to Current Technology or FACT library, at the end of Chapter 7 in the textbook (pp. 340–358) from the perspective of a database administrator assigned to build this database. Select one of the entities shown in the ERD for Tiny College’s database in Figure P7.56 on page 341. What data types would you use for the attributes in this entity? How would you code a CREATE TABLE statement to implement this entity as a table in the database?
- Continue examining the Tiny College case at the end of Chapter 7 in the textbook (pp. 340-358), but this time from the perspective of a manager in the organization. What is one example of a report from the database that a manager might want to receive? What data items would appear on the report, and what attributes and entities would these data items come from? How would you code a SQL SELECT query to retrieve this information?
DQ 2 WORKOUT ROOM
Please share your expertise on this Week’s Lab Assignment. Give examples or discuss topics you might consider using and help a classmate. Please post two (2) times throughout the week. (On two different days.)
BIAM 530 Week 3 Lab Querying the Database With SQL
BIAM 530 Week 4 Database Life Cycle and Project Planning
BIAM 530 Week 4 Disussions
DQ 1 DATABASE LIFE CYCLE & ALTERNATIVES TO THE TRADITIONAL SDLC
- Find an article explaining the database life cycle in the DeVry University online library or on an authoritative website. What are the steps in the life cycle according to your source? How do these compare to the steps listed in Chapter 9 of our textbook?
- Describe an alternative to the traditional SDLC or “waterfall” software development process, such as rapid application development (RAD) or agile development. What are the advantages and disadvantages of this alternative compared to the traditional SDLC? How would this alternative approach affect database development?
BIAM 530 Week 4 Homework
Green Vehicles Inc. (GVI) operates a chain of car dealerships that sell and service electric car models from several manufacturers, including the Chevrolet Spark, Nissan Leaf, BMW i3, and others. Because the parts departments at each dealership must stock parts from multiple manufacturers, the company requires a custom database system to manage parts inventories. You have been hired as a consultant to advise GVI’s managers on the best process to follow in developing such a system.
Research the topic of database development and write a three to five page paper that addresses the following questions:
- What software development process (SDLC) should GVI follow for its inventory management system, and what are the major steps in this process and what methodology would you recommend?
- What database development process (DBLC) should GVI follow for the inventory database in this system, and what are the major steps in this process?
- What are some best practices that GVI should observe to help ensure the success of this project?
The paper should be in APA format, double-spaced using 12-point Times New Roman font, with a cover page and reference list. The cover page and reference list do not count toward the required page count. The paper should include at least three references, one of which can be the course textbook. Please follow the 80/20 Rule for all written assignments: 80% or more of the work is in your own words and 20% or less is in the words of another author. The paper will be graded using the following rubric.
Category | Points | Percent | Description |
---|---|---|---|
Content | 60 | 55% | The paper is of the required length and fully addresses topics provided including the answers to the three questions above. Examples and supporting details are provided for each main point. Authoritative sources are cited as support. The paper is at least 80% in the student’s own words (i.e., no more than 20% direct quotations from a source). |
References | 15 | 13.5% | The reference list includes at least three references. References are authoritative and represent either scholarly peer-reviewed or expert professional sources. The reference list is in APA format and is free of typographical, grammar, spelling, and formatting errors. Reference list can include text as one of the three references. |
Formatting | 10 | 9% | The paper is in 12-point Times New Roman font, double-spaced, and includes a cover page, introduction, body of the report, summary or conclusion, and references. The paper conforms to APA format, including use of standard paragraph format and headings. Tables, if included, use table numbers and titles. Figures, if included, use figure numbers and captions. |
Organization and Cohesiveness | 15 | 13.5% | The paper includes an introduction that generates interest in the topic and previews the main points to be covered, a bodythat develops each main point, and a conclusion that summarizes the main points covered. There is a logical flow of ideas throughout the paper. There is a clear thesis statement for the paper and a clear topic statement for each major section. Appropriate transitions are used between topics and subtopics. Discussion should include answers to the three (3) questions above. |
Editing | 10 | 9% | The paper uses a professional writing style and is free of typographical, spelling, and grammar errors. |
Total | 100 | 100% | A quality paper will meet or exceed all of the above requirements. |
Submit your assignment.
Rubric
Criteria | Ratings | Pts | |
---|---|---|---|
Content The paper is of the required length and fully addresses topics provided. Examples and supporting details are provided for each main point. Authoritative sources are cited as support. The paper is at least 80% in the student’s own words (i.e., no more than 20% direct quotations from a source).
|
|||
References The reference list includes at least three references. References are authoritative and represent either scholarly peer-reviewed or expert professional sources. The reference list is in APA format and is free of typographical, grammar, spelling, and formatting errors.
|
|||
Formatting The paper is in 12-point Times New Roman font, double-spaced, and includes a cover page, introduction, body of the report, summary or conclusion, and references. The paper conforms to APA format, including use of standard paragraph format and headings. Tables, if included, use table numbers and titles. Figures, if included, use figure numbers and captions.
|
|||
Organization & Cohesiveness The paper includes an introduction that generates interest in the topic and previews the main points to be covered, a body that develops each main point, and a conclusion that summarizes the main points covered. There is a logical flow of ideas throughout the paper. There is a clear thesis statement for the paper and a clear topic statement for each major section. Appropriate transitions are used between topics and subtopics.
|
|||
Editing The paper uses a professional writing style and is free of typographical, spelling, and grammar errors.
|
|||
Total Points: 110.0
|
BIAM 530 Week 5 Distributed Databases, Big Data, and NoSQL Databases
BIAM 530 Week 5 Discussions
DQ 1 BIG DATA ANALYSIS & CLOUD COMPUTING
- Research how organizations are using analysis of big data to help accomplish their goals. What is the most interesting application of big data analysis taking place right now? What new applications are expected within the next few years?
- What are some advantages and disadvantages of cloud computing?
DQ 2 WORKOUT ROOM
Please share your expertise on this Week’s Lab Assignment. Give examples or discuss topics you might consider using and help a classmate. Please post two (2) times throughout the week. (On two different days.)
BIAM 530 Week 5 Lab Analyzing Data With Hadoop
BIAM 530 Week 6 Business Intelligence, Data Warehousing, and Key Performance Indicators (KPIs)
BIAM 530 Week 6 Discussions
DQ 1 BUSINESS INTELLIGENCE AND DATA WAREHOUSING & KEY PERFORMANCE INDICATORS (KPIS)
- Discuss how a business organization might use data marts as a part of their management and decision support strategy.
- You are a business analyst for a company that is launching a major initiative to improve the quality of its customer service. How would you go about selecting KPIs for this initiative?
DQ 2 WORKOUT ROOM
Please share your expertise on this Week’s Lab Assignment. Give examples or discuss topics you might consider using and help a classmate. Please post two (2) times throughout the week. (On two different days.)
BIAM 530 Week 6 Lab Building and Using a Data Warehouse
BIAM 530 Week 7 Database Administration and Database Security
BIAM 530 Week 7 Discussions
DQ 1 DATABASE ADMINISTRATION & DATABASE SECURITY
- What is the role of a database administrator (DBA) in a business intelligence initiative?
- Research a recent incident of a data breach. What data were lost or stolen? What was the cost to the organization and to the other parties? How did the breach occur and how might it have been prevented?
BIAM 530 Week 7 HOMEWORK
Mobile Adventures LLC develops and distributes adventure games for Apple (iOS) and Android smartphones and tablets. The company currently has three popular games in distribution and is developing two more. Customers pay an initial fee to download each game plus an annual subscription fee for continued access to the company’s servers for multi-user play. The company also places mobile advertising within the games as an additional revenue stream. Mobile Adventures collects a variety of data on each player, including the player’s e-mail address, type of mobile device, frequency and duration of game play, and highest level reached within each game. Each time a user views or clicks on an in-game ad is also recorded.
You have been hired as a consultant by Mobile Adventures to advise them on how they can best realize additional value from their collected user data and how this data should be managed and protected.
Research the topic of data management and protection and write a three to five page paper that addresses the following questions:
- How would you justify to Mobile Adventures’ executives that they should treat their player data as a valuable business asset?
- What are at least two ways in which Mobile Adventures could monetize (i.e., realize additional revenue from) the data they currently collect from game players?
- What are the major threats to Mobile Adventures’ data, and what policies and procedures would you recommend to mitigate these threats?
The paper should be in APA format, double-spaced using 12-point Times New Roman font, with a cover page and reference list. The cover page and reference list do not count toward the required page count. The paper should include at least three references, one of which can be the course textbook. The paper will be graded using the following rubric.
Category | Points | Percent | Description |
---|---|---|---|
Content | 60 | 60% | The paper is of the required length and fully addresses topics provided including the questions listed in the scenario. Examples and supporting details are provided for each main point. Authoritative sources are cited as support. The paper is at least 80% in the student’s own words (i.e., no more than 20% direct quotations from a source). |
References | 15 | 10% | The reference list includes at least three references. References are authoritative and represent either scholarly peer-reviewed or expert professional sources. The reference list is in APA format and is free of typographical, grammar, spelling, and formatting errors. Your text may be used as one of the three references. |
Formatting | 10 | 10% | The paper is in 12-point Times New Roman font, double-spaced, and includes a cover page, introduction, body of the report, summary or conclusion, and references. The paper conforms to APA format, including the use of standard paragraph format and headings. Tables, if included, use table numbers and titles. Figures, if included, use figure numbers and captions. |
Organization and Cohesiveness | 15 | 10% | The paper includes an introduction that generates interest in the topic and previews the main points to be covered, a body that develops each main point, and a conclusion that summarizes the main points covered. There is a logical flow of ideas throughout the paper. There is a clear thesis statement for the paper and a clear topic statement for each major section. Appropriate transitions are used between topics and subtopics. |
Editing | 10 | 10% | The paper uses a professional writing style and is free of typographical, spelling, and grammar errors. |
Total | 110 | 100% | A quality paper will meet or exceed all of the above requirements. |
Submit your assignment.
Rubric
BIAM530 Week 4, 7 Homework Rubric
Criteria | Ratings | Pts | |
---|---|---|---|
Content The paper is of the required length and fully addresses topics provided. Examples and supporting details are provided for each main point. Authoritative sources are cited as support. The paper is at least 80% in the student’s own words (i.e., no more than 20% direct quotations from a source).
|
|||
References The reference list includes at least three references. References are authoritative and represent either scholarly peer-reviewed or expert professional sources. The reference list is in APA format and is free of typographical, grammar, spelling, and formatting errors.
|
|||
Formatting The paper is in 12-point Times New Roman font, double-spaced, and includes a cover page, introduction, body of the report, summary or conclusion, and references. The paper conforms to APA format, including use of standard paragraph format and headings. Tables, if included, use table numbers and titles. Figures, if included, use figure numbers and captions.
|
|||
Organization & Cohesiveness The paper includes an introduction that generates interest in the topic and previews the main points to be covered, a body that develops each main point, and a conclusion that summarizes the main points covered. There is a logical flow of ideas throughout the paper. There is a clear thesis statement for the paper and a clear topic statement for each major section. Appropriate transitions are used between topics and subtopics.
|
|||
Editing The paper uses a professional writing style and is free of typographical, spelling, and grammar errors.
|
|||
Total Points: 110.0
|
BIAM 530 Week 8 Final Week
BIAM 530 Week 8 Discussion
BIAM 530 Week 8 FINAL EXAM
INSTRUCTIONS
Here is some information about your Final Exam.
- This Final Exam covers all COs and Chapters 1-4, 6-9, 12, and 13-15.
- This Final Exam is worth 280 total points, which include the following questions:
- 10 multiple choice questions at 5 points each;
- seven essay questions at 30 points each; and
- one essay question at 20 points.
- You have 3 hours, 30 minutes to finish the Final Exam.
- Remember to SAVE frequently, because when the time limit is reached, you will automatically be exited from the exam.
By submitting this work, I am attesting that it abides by the Student Honor Code.
Course Tutor helps in providing the best essay writing service. If you need 100% original papers for BIAM 530 Full Course DeVry, then contact us through call or live chat.
BIAM 530 Full Course DeVry
![Best BIAM 530 Full Course DeVry](http://coursetutor.us/wp-content/uploads/2018/05/eb-10.png)
ACCT 553 DeVry, BIAM 500 DeVry, CIS 500 STR, CIS 558 STR, ENG 105 GCU, FIN 390 DeVry, FIN 504 GCU, HCA 545 GCU, HCA 699 GCU, HLT 306 GCU, HLT 362 GCU, HLT 555 GCU, HLT 610 GCU, HLT 665 GCU, HOSP 594 DeVry, HRM 600 DeVry, MAT 144 GCU, MGMT 600, MGT 599 STR, MGT 655 GCU, MKT 373 GCU, PSY 362 GCU, PSY 565 GCU, PSY 575 GCU, PSY 665 GCU, SOC 102 GCU, SOC 320 GCU, SOC 372 GCU, SOC 412 GCU, NSG 6440 SU, HIM 515 GCU, NSG 4029 SU, HIM 615 GCU, NSG 3029 SU, NSG 4055 SU, NSG 6630 SU, NSG 6005 SU, CRMJ 310, PSY 510 GCU, CRMJ 300 Devry, CRMJ 425, SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCU, MGT 640 GCU, CIS 527 STR, SOC 436 GCU,ACC 502 GCU, FIN 504 GCU , MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVry, NETW 203 DeVry, NETW 205 DeVry, ECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU ,BIAM 570 DeVry, PSY 402 GCU , SOC 480 GCU , BIAM 530 DeVry
Reviews
There are no reviews yet.