JUST PART III PLEASE Columbia Pictures Inc. is a film production house. It has the following rules: An actor is identifi

[answerhappygod]

JUST PART III PLEASE
Columbia Pictures Inc. is a film productionhouse. It has the following rules:
An actor is identified by a first name, lastname, gender, (add a new attribute)
A film is identified by a title, a language, acategory and has a duration, (add a new attribute)
A producer is identified by a first name, and alast name (add a new attribute)
For each film, anactor is assigned arole.
This list of attributes is not exhaustive. You need to addone attribute for each entity.
PART I :
Designing the logical data model of the system:ERD
PART II :
Respecting the third normal form, design thephysical data model (RDM)
1. Identify (from the logical data model) the
2. Design the relational data model showing all thecharacteristics and identifying primary and foreign keys, and thenmap the relationships with their cardinalities
PART III:
DDL: Data Definition Language
DML: Data Manipulation Language Implementing thedatabase using Transact-SQL
DQL Data Query Language
Querying the Database Schemausing Transact-SQL
1- Request the system objects (sys.sysobjects)to display the name, the type and the type description, the createddate and the updated date of the following objects:
2- Request the system objects (sys.sysobjects)to display the total number of each type of object as follows:
/*** Resulset with its header*****
totaltype type_desc
? U USER_TABLE
? PK PRIMARY_KEY_CONSTRAINT
? F FOREIGN_KEY_CONSTRAINT
*/