2 Er Diagram Is Based On The Business Rules And Should Clearly Label All Entities En 2849787

2. ER diagram is based on the business rules, and should clearly label all entities, entity attributes, primary and foreign keys, relationship and connectivity. The cardinality is optional.Instruction: Use professional software (e.g., MS Office Visio) to draw the ER diagram. Crow’s Foot notation is preferable.(40 marks)3. Develop relational schemas. Relational schemas should be derived using the ERD. You should map cardinalities correctly from ERD to Relational Schema. You should clearly indicate the referential integrity constraints (primary and foreign key relationships) using arrows. Clearly indicate datatype for each attribute.e.g.Emp( eid: integer, ename: string(50), address: string(100), did: number)Dept(did: number, dname : string (15)) 4. SQL commands1. Create all tables in Deakin Oracle DBMS (about eight tables including compositetables) and Populate the tables with sample data (10 records in each table isrecommended).2. Alter the student table and add new field Date of Birth for student table. Type fordate of birth should be date.3. Increase the annual salary for all staff member by 5%.4. List the course numbers, course names a student who is doing computer sciencemajor could enrol for.5. Find the students with age between 18 and 21. Print their student number, nameand the age with the major.6. Create your own query. It must include a nested query. Submit the following:i question your query is answering the SQL queryii the mark for this question will depend on the complexity of the query.iii higher marks will be given for queries that are more complex and/or innovative.(15 marks)iv if you do not provide a description of what question the query is answering, you will get zero for this query.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"