Reference no: EM132117125
Question - How do you draw the ERD?
Erd means Entity relationship diagram
MIS Database Project
Georgia Gwinnett College (commonly called Georgia Gwinnett or simply GGC) is a four-year public college in Gwinnett County, Georgia, United States and a member of the University System of Georgia.
Georgia Gwinnett College opened on August 18, 2006 as one of the nation's first four-year public college founded in the 21st century, and the first four-year public institution created in Georgia in more than 100 years. It has grown rapidly from its original 118 students in 2006 to nearly 11,000 in 2014.
All the students of GGC have a unique Student ID. Together with that other personal information of students need to be stored. There are about 500 Faculty at GGC who are indentified by their Full Name. For each faculty contact information need to be stored too. Student mentoring is a very important aspect of GGC. Each faculty can mentor as many as thirty students.
While the course offered at GGC are identified by their CRN, course names. Credit hours are something needs to be stored as well. A faculty can teach up to three courses each semester and a course is taught by only one faculty at a given time.
A student can enroll in no more than six courses, In order to keep the class size small, not more than fifty students are allowed to enroll in a particular course. There are some instructional tools available at GGC which are identified by their ToolID. A faculty as well as a student can borrow those tool(s) for a course. When a faculty or student borrows a tool(s) due date is assigned.
There is cost associated with this borrowing activity. GGC also has Medical facility where there are doctors who are identified by their full name. Students can visit the medical centers to see a doctor. When a student visits a doctor, each visit needs to be uniquely identified. For each visit the visit date, symptoms, and the provided treatments also need to be stored.
|
Which of the following return an array
: CSS vendor prefixes are a way for browser companies to add support for experimental features before those features become part of the CSS specification.
|
|
What amount would he report as taxable income
: Gross salary$60,080 Interest earnings$220 Dividend income$160 Itemized deductions$7,180 Adjustments to income$1,200
|
|
How much net working capital does the firm need to fund
: Dandee Lions, Inc., has a cash balance of $115,000, accounts payable of $230,000, inventory of $213,000, accounts receivable of $329,000, notes payable
|
|
Provide a comparative analysis of the debt and equity
: Discuss whether the financial accounting and reporting should be regulated or manager should be allowed to disclose financial accounting information voluntarily
|
|
How do you draw the erd
: Georgia Gwinnett College opened on August 18, 2006 as one of the nation's first four-year public college founded in the 21st century.
|
|
If the fed decides to sell treasury securities
: If the Fed decides to sell Treasury securities, does the money supply increase, decrease, or remain unchanged? Explain why
|
|
Will the following command sort the file on the group name
: The file contains three columns of information : username, uid number and group name respectively, separated by a field separator.
|
|
Capital budgeting decision
: Sunk costs are associated with past expenditures and are therefore relevant to the capital budgeting decision. Can this statement be true?
|
|
Explain what is a process
: A group diary and time management system is intended to support the timetabling of meetings and appointments across a group of co-workers.
|