Transcribed TextTranscribed Text

Topic: Design a database for a University course scheduling system. Requirements: The system shall store data about professors, students, courses (including course sections), buildings, classrooms, and semesters Professors shall be allowed to teach multiple courses and course sections Students shall be allowed to register for multiple courses Students shall be able to retrieve their grade for each registered course Students shall be able to retrieve their overall GPA Courses shall be allowed to have multiple sections Course sections shall be assigned a semester, time, professor, and classroom The system shall store all other pertinent information Deliverable: ERD that meets the following standards Each entity and its attributes are represented in a compact box/list Primary key(s) are denoted with * Relationships are drawn using the Crow's foot method Attributes have their domains noted Domains are noted with sizes Diagram is in electronic format (no scans/photos of handwritten documents) Example ERD: Delivery Order Detail Delivery *delivery id inm *delivery id 10 delivery date du *orderid "1 supplierid irt Korderdetallid Order Detail Order * order detai id in *orderic int. productid in orderdate order id "1 headquartersid irt product quantity int Branch > Hoadcuarters H *branchid inm theadquartes id n. branchid varchur (20)

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:

    for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Database Development Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats