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

Lossless-join decomposition, what is Lossless-join decomposition

what is Lossless-join decomposition

Type of views-data control, Type of views : Simple views and Difficult ...

Type of views : Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Mention constraints to create command ddl, Mention the type of constraints ...

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

Applications and goals of dbms, What do you mean by DBMS? What is its need ...

What do you mean by DBMS? What is its need and what are its goals. Explain? OR Explain Data Base Management System? Sol. Database management system is a

Define shared locks, Define Shared locks? Ans: Shared lock: Throughout ...

Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he

What is transaction, What is transaction? Transaction is a unit of prog...

What is transaction? Transaction is a unit of program implementation that accesses and possibly updated several data items.

Implementing a data warehouse, (a) Data warehouse can be defined as "a sub...

(a) Data warehouse can be defined as "a subject-oriented, integrated, time-variant, non-volatile collection of data" in support of management's decision making process. Explain ea

Explain entity integrity and referential integrity rules, Explain entity in...

Explain entity integrity and referential integrity rules within relational model. Show how these are realized in SQL? Entity Integrity Rule - No primary key value could be nu

Describe sequential file organization, Describe sequential file organizatio...

Describe sequential file organization. Explain the rules for (i) Inserting a new record. (ii) Deleting an existing record. Ans:A sequential f

Create a er diagram to show customer accounts, Information about a bank is ...

Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha

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