Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
create the database of the system in relational database system (mySQL, ORACLE....) populate the database with some test data

create the database of the system in relational database system (mySQL, ORACLE....) populate the database with some test data

Systems Architecture
Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
See similar textbooks
icon
Related questions
Question
create the database of the system in relational database system (mySQL, ORACLE....) populate the database with some test data semester semester name String +semester id int (pk) +year int program program name String mandatory courses String[] +optional courses String[] sem/cor +director String semester id (k) course id (fk) minimum gpa int payment +collage String program id int (pk) course student +course code int *course title String credit hours int pre-requisite String +date int + name String +student id int (pk) -adress String -phone number int - email String +coruse id int (pk) -apa double section id (fk) program id (fk) section section number int +class room int teacher name String time int +day String rank String -students String[] +teacher id int (pk) section id (pk) program id (fk) coruse id (fk) building id (fk) teacher id (fk) building +name String building id int +number of classrooms int prog/cor program id (fk) coruse id (fk) stu/con student id (fk) course id (fk) + payment id int (pk) +total amount int +due date int +pay cash boolean +pay online boolean student id (fk)
Transcribed Image Text:create the database of the system in relational database system (mySQL, ORACLE....) populate the database with some test data semester semester name String +semester id int (pk) +year int program program name String mandatory courses String[] +optional courses String[] sem/cor +director String semester id (k) course id (fk) minimum gpa int payment +collage String program id int (pk) course student +course code int *course title String credit hours int pre-requisite String +date int + name String +student id int (pk) -adress String -phone number int - email String +coruse id int (pk) -apa double section id (fk) program id (fk) section section number int +class room int teacher name String time int +day String rank String -students String[] +teacher id int (pk) section id (pk) program id (fk) coruse id (fk) building id (fk) teacher id (fk) building +name String building id int +number of classrooms int prog/cor program id (fk) coruse id (fk) stu/con student id (fk) course id (fk) + payment id int (pk) +total amount int +due date int +pay cash boolean +pay online boolean student id (fk)
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Concurrency control
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS