PLEASE DONOT ANSWER THE FIRST QUESTION. SECOND QUESTION ISBASED ON THE FIRST QUE

Question

PLEASE DONOT ANSWER THE FIRST QUESTION. SECOND QUESTION ISBASED ON THE FIRST QUESTION. COULD YOU PLEASE ANSWER THE SECONDQUESTION. PLEASE REPLY AS SOON AS POSSIBLE. 1.) Construct an E-R diagram for TEXAS A & M universitystudent reseach organization. The organization mains data abouteach research project, including the advisor / professor, thestudent participated. For each student - project pair, the weeklyworking hour is recorded. Document all assumptions that youmake. 2.) USING ABOVE E-R MODEL TO CREATE A MYSQL DATABASE/TABLES.WRITE SQL TO DEFIND DATA BASE AND TABLE SCHEME DATA BASE NAME---------------------- TABLE NAME(S) ------------(      ) ------------(      ) ------------(      ) ------------(      ) ------------(      ) PLEASE DONOT ANSWER THE FIRST QUESTION. SECOND QUESTION ISBASED ON THE FIRST QUESTION. COULD YOU PLEASE ANSWER THE SECONDQUESTION. PLEASE REPLY AS SOON AS POSSIBLE. 1.) Construct an E-R diagram for TEXAS A & M universitystudent reseach organization. The organization mains data abouteach research project, including the advisor / professor, thestudent participated. For each student - project pair, the weeklyworking hour is recorded. Document all assumptions that youmake. 2.) USING ABOVE E-R MODEL TO CREATE A MYSQL DATABASE/TABLES.WRITE SQL TO DEFIND DATA BASE AND TABLE SCHEME DATA BASE NAME---------------------- TABLE NAME(S) ------------(      ) ------------(      ) ------------(      ) ------------(      ) ------------(      )

Explanation / Answer

Dear, Creating Database: Syntax: Create databse databasename                            Create databse texa1 Create tables: Syntax: Create or Replace Table table name(fieldnames [data types])    Create or Replace Table Professor(ssn number(4),age number(2), rank number(2), speciality varchar(20))    Create or Replace Table Project(pidnumber(3),sponsor varchar(30),start_date date,end_date date,budgetnumber(5,2))    Create or Replace Table Graduate(ssnnumber(3),age number(2), deg_prog varchar(15),namevarchar(20))    Create or Replace Table Dept(dnonumber(3),dname varchar(30),office varchar(20))    Create or Replace Table Advisor(ssnnumber(3),senior number(2),grad varchar(10)) for remaining tables also same above syntax need tofollow. I hope this will helps you!!!!!!!!         

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.