CIS 336 All Discussions

$29.00

CIS 336 All Discussions
We hear the term database all the time. Give some examples of databases that you interact…

Description

CIS 336 All Discussions

CIS 336 All Discussions

Week 1-7 All Posts 581 Pages 

Normal Forms and Entity Relationship Diagrams and Lab Forum Discussions Week 1 All Students Posts 80 Pages 

https://www.hiqualitytutorials.com/product/cis336-discussions-week-1/

Normal Forms and Entity Relationship Diagrams – 40 Pages 

https://www.hiqualitytutorials.com/product/cis-336-normal-forms/

We hear the term database all the time. Give some examples of databases that you interact with on a regular basis. What makes a database relational? What is a file storage system? How does a relational database differ from a file storage system?  Class would you consider a Microsoft Excel spreadsheet a relational database?  Why/why not? How about Excel inclusion for “referential integrity”? What about concerns regarding end-users training to recognize spreadsheet limitations? Under what circumstances would data inconsistencies occur in a database?…

Lab Forum – 40 Pages 

https://www.hiqualitytutorials.com/product/lab-forum-week-1/

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. What is the difference between an operational and a transactional database? What is the main purpose for a data warehouse? What distinguishes an operational versus a data warehouse database? How would you compare a “relational database” against a “Network database”?….

Developing a Good Data Model and Lab Forum Discussions Week 2 All Students Posts 72 Pages 

https://www.hiqualitytutorials.com/product/cis336-discussions-week-2/

Developing a Good Data Model – 37 Pages 

https://www.hiqualitytutorials.com/product/developing-good-data-model/

The database data model is the communication link between the designer, applications programmer, and user. Contribute your views on what constitutes a good data model and why. What is CARDINALITY? How about an example?  How does cardinality/ordinality portrayed using Crow’s Feet? what constraints enforce semantic integrity?…

Lab Forum – 35 Pages 

https://www.hiqualitytutorials.com/product/lab-forum-week-2/

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. Briefly describe the different types of database keys. Class who wants to enlighten us with an example for a super key? How about a business application that we would need to use a super key? A requirement of entity integrity is that all primary key entries are unique and no part of a primary key may be null. Do you concur, why/why not?…

Building the Physical Model and Lab Forum Discussions Week 3 All Students Posts 83 Pages 

https://www.hiqualitytutorials.com/product/cis336-discussions-week-3/

Building the Physical Model – 40 Pages 

https://www.hiqualitytutorials.com/product/cis336-building-physical-model/

What is the importance of constraints in a physical model? What role do different constraints play in maintaining referential integrity and data integrity? It is possible for a table to be in BCNF but not in 3NF; do you concur? Why or why not?  Revisiting foreign keys, what would impact the ability to add or delete rows from a table or the ability to drop tables from a database schema?  What should be some of the considerations?….

Lab Forum – 43 Pages 

https://www.hiqualitytutorials.com/product/lab-forum-week-3/

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. How about sharing with the class 2-3 SQL insert statements to populate the Student table? Do you have any tips on how to use Snipping Tool?  Are there are similar tools available that you want to share with the class?….

CIS 336 All Discussions

Understanding the SELECT Statement and Lab Forum Discussions Week 4 All Students Posts 105 Pages 

https://www.hiqualitytutorials.com/product/cis336-discussions-week-4/

Understanding the SELECT Statement – 48 Pages 

https://www.hiqualitytutorials.com/product/understanding-the-select-statement/

Reports are generated using queries to a database. The SELECT statement is used to retrieve data from one or many tables in a database. Just as in other programming languages, understanding the syntax of a select statement is key. Let’s first discuss the key clauses in a SELECT statement and the purpose of each.  What are the different clauses of the SELECT statement? Which SQL “SELECT” attribute elements are required and which are optional? How about sorting query results…

Lab Forum – 57 Pages 

https://www.hiqualitytutorials.com/product/lab-forum-week-4/

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. Class who wants to briefly explain that the UNION statement combines rows from two or more queries without including duplicate rows?  How about an example? Class who wants to describe/dissect for us the following SQL statement?…

Getting Data From Multiple Tables and Lab Forum Discussions Week 5 All Students Posts 84 Pages 

https://www.hiqualitytutorials.com/product/cis336-discussions-week-5/

Getting Data From Multiple Tables – 42 Pages 

https://www.hiqualitytutorials.com/product/getting-data-multiple-tables/

It is not uncommon to have to retrieve data that resides in several tables, especially when formulating a report. Discuss some of the performance issues when querying three or four tables at a time. Briefly explain the difference between an equijoin and a non-equijoin. What about a “trigger”?  What is it? What would be its purpose? Briefly discuss how a NATURAL JOIN, JOIN ON, and JOIN USING are alike and yet different. How is an INNER JOIN different from a LEFT OUTER JOIN? How do you decide when to use each type of join?…

Lab Forum – 42 Pages 

https://www.hiqualitytutorials.com/product/lab-forum-week-5/

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. Enlighten us with 1-2 examples using SYSDATE and displaying different pieces of information.  What is the key difference between the following SQL LIKE statements?  Why would you not want to specify the entire characters? LIKE ‘Burt%’ versus  LIKE ‘Burt Ruggles%’  Based on your experiences with other SQL languages (like MySQL, all SQL-standard DBMSs support date and time functions?…

How Group Functions Differ From Single-Row Functions and Lab Forum Discussions Week 6 All Students Post 83 Pages 

https://www.hiqualitytutorials.com/product/cis336-discussions-week-6/

How Group Functions Differ From Single-Row Functions – 38 Pages 

https://www.hiqualitytutorials.com/product/how-group-functions-differ/

What are some examples of group functions, and how do they differ from single-row functions? Discuss differences between SUM and COUNT. What be the expected results if the following SQL statements are executed?

SELECT retail

FROM books, publisher

WHERE books.pubid = publisher.pubid and publishername = ‘PRINTING IS US’;

 UPDATE books

SET retail = (retail * 1.05)

WHERE pubid =

    (SELECT pubid

     FROM publisher

     WHERE publishername = ‘PRINTING IS US’);

 SELECT retail

FROM books, publisher

WHERE books.pubid = publisher.pubid and publishername = ‘PRINTING IS US’;

What is the purpose for using HAVING clause? What’s the difference between the TO_CHAR and TO_DATE functions when working with date values?…

Lab Forum – 45 Pages

https://www.hiqualitytutorials.com/product/lab-forum-week-6/

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. MySQL will allow you to increase, but not decrease the size of a column; however, if the system you are working on allows you to make changes to the column width without restrictions, what would happen to a customer first name field that went from 20 characters to eight characters? If this is not a primary key, does it matter? What is the difference between DROP, TRUNCATE, and DELETE? How about some examples to contrast DROP, TRUNCATE and DELETE? What is the purpose for the HAVING clause in MySQL?  How about enlighten us with an SQL examples that include the HAVING clause?…

CIS 336 All Discussions

Database Views and Lab Forum Discussions Week 7 All Students Posts 74 Pages 

https://www.hiqualitytutorials.com/product/cis336-discussions-week-7/

Database Views – 35 Pages 

https://www.hiqualitytutorials.com/product/cis-336-database-views/

What are the advantages of selecting data from a view over selecting data from a base table? All in addition to limiting the actual tables or columns that a user has access to, you can also limit what the user does? What are some of the ROLES you might assign to users and what would these roles do? Beyond monitoring databases activities by end users, how can logs be utilized say for security purposes? What special considerations must you take into account when contemplating the introduction of a DBMS into an organization? Why prior to modifying a table is a good practice for locking the table?…

Lab Forum – 39 Pages 

https://www.hiqualitytutorials.com/product/lab-forum-week-7/

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. Looking back on last week’s lab, some of the queries required you to join at least four tables. How would a view make it easier to retrieve this same information? What MySQL string function should you use to list the first three characters of a company’s EMP_LNAME values? Give an example, using a table named EMPLOYEE. Why is it a good idea to remove a view prior to recreating it? What is the purpose for the following MySQL statement? What is dynamic SQL and how does it differ from static SQL? Consider the data in any Human Resource database, if you had a “user front-end” (GUI) for this database, what would be some common types of information that you might want to display on one page? How would you do this with a view? Why/why not?…

CIS 336 All Discussions

DeVry