Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Question:
Using the data model express the following queries in SQL.
(a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and the Town and Manager number to be the Foreign key of the table. What are the assumptions you have to make for the code to compile successfully?
(b) Add a new column in the table named Cinema to store the telephone number of the cinema.
(c) Add a new record in the Cinema Table with the following values:
(d) Modify the population value for Cardiff from 300,000 to 350,000.
(e) List all the cinema names and the town in which the film ‘Star Wars' has been shown.
(f) List all the film names and their respective film taking (the number of shows) which has been played at Rex found in Cardiff.
(g) Create a view named Cinema_Rex_View which will shows all the films played at Rex found in Cardiff. The views should have the following columns.
how many types of data model in DBMS? explain data abstraction with its different level
Company XYZ is an advertising company. It has its own website but the search facilities offered are not reliable. The company is willing to invest to acquire new machines and sof
Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep
What is multiple relationship ?
How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op
What are the two types of errors? The two types of errors are: a) Logical error b) System error
Explain the Weak Entity Set An Entity set which does not have sufficient attribute to make a primay key is known as weak entity set. For instance, dependents of an employee in
What is called query processing? Query processing refers to the range of activities included in extracting data from a database.
What is entity in DBMS? Entity: A DBMS entity is either a thing in the modelled world or a drawing element in an ERD.
Un-Normalized Form (UNF) If a table having non-atomic values at every row, it is said to be in UNF. An atomic value is something that cannot be further decomposed. A non-atomic
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd