5. Convert the following E/R diagrams to a relational database using the straight-E/R method.

With the following Object Oriented Relational Database schema, select the attributes that a tuple in Teachers would have.     create type Person    (ID varchar(20) primary key,     name varchar(20),     address varchar(20))  ref from(ID); create table people of Person;     create table students    ( degree varchar (20))    inherits people ;create table teachers    ( salary integer )    inherits people ;     a. id   b. salary   c. degree   d. name

02: Construct an E-R or UML diagram for the following SALES COMPANY database which has network of salespersons over all Iraqi cities: Customer(CustomerNo, CustomerNarne, SPNO, HQCity) CustomerEmpl(CustomerNo, EmployeeNo, EmpNamem, Title) Office(OfficeNo, City, Telephone, Ocize) Product(ProductNo, ProductName, UnitPrice) Sales(SPNO, ProductNo, Quantity) Salesperson(SPNO, SPName, CommisionPersentage, YearOfHire)

Explain the Third Normal Form (3NF) and how it further refines database design by eliminating transitive dependencies.

No direct connections between external entities and the database are permitted. This is one of the data flow diagram design concepts to remember. What are the ramifications of this suggestion?

Read Scnerio carefully :  Make a Propose and optimal database design in RDBMS for a super store. In which clients came and can purchase products according to their likes and dislikes. Super store have same products of different companies. In the end client received a receipt of their purchase from counter he/she go for bill. Database also save records of stock according to FIFO system. Required to define Entities and their attributes Attributes Types  Each Attribute Required  Define keys of each entity Define relationship between the entities.

Do any data structure components need to be recognized all the way up at the database layer?

Consider a database with tables with parent tables and tables without parent tables. What differentiates controllers used to manage data for tables with and without parent tables?a) The routing algorithm to the controllerb) The number of methods in the controllerc) The controller method parameters, redirections, and model manipulationsd) Views are called from the models instead.

Describe the Second Normal Form (2NF) and give an example of how it's applied in database design.

Discuss the Second Normal Form (2NF) and its role in database structure.