CMIS 420 Homework Assignment 2, Database Management System

CMIS 420 Homework Assignment 2, Database Management System

Assignment Help:

describe all the tables you have created.
?get table_name, status, num_rows, user_stats in user_tables system view
?get table_name, constraint_name, constraint_type in user_constraints or user_cons_columns system view. you need to filter out the records unrelated to our database.
?get total record numbers from the following tables: movies, distributed_movie_list, movie_rent_list, customers, orders and order_items. Compare the numbers of row counts with the num_row in user_tables. See whether any inconsistency.
?display title, director_name, company names with one query
?display title, actor_name with one query
?spool the output to a text file (it should be labeled with your name)
?Submit your script and the spooled file for grading.

Related Discussions:- CMIS 420 Homework Assignment 2

A table joined with itself is called, A table joined with itself is called ...

A table joined with itself is called ? A table joined with itself is known as self join table. Normal 0 false false false EN-IN X-NONE X-NONE

Relational model, A model in database system mostly defines the organisatio...

A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represen

Implementation of integrity rules, Question 1 Describe the following- ...

Question 1 Describe the following- Clustering Indexing Question 2 Explain the following with suitable real time examples- Implementation of Integrity rules

Having clause with sub queries, Having Clause with sub queries: First we h...

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)

When is update_statistics command used, When is UPDATE_STATISTICS command u...

When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place

Accounting and external reporting, List the internal controls that should b...

List the internal controls that should be in effect solely because a EDP system is employed, classifing them as (1) Those controls pertaining to input of information and (2) All ot

Define the query optimisation, Define the Query optimisation The query ...

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

Cascading rollback, explain cascading rollback

explain cascading rollback

Er diagram for accounts, how draw er diagram

how draw er diagram

Define cardinality and participation constraints, Define cardinality and pa...

Define cardinality and participation constraints on a relationship type, completeness constraint on generalization. Ans: Cardinality defines the number of entities to wh

Write Your Message!

Name

Email id

Message

Verfication Code

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

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