Question: (14 points) Problem 6-34, p.283, where the beginning words Write a database description means Write a SQL statement ... This problem requires you to create

(14 points) Problem 6-34, p.283, where the beginning words Write a database description means Write a SQL statement ...

This problem requires you to create a database with six tables based on Figure 6-11 on p.283 (see the paragraph before this problem). The 6 tables are linked as: FACULTY-QAULIFIED-COURSE-SECTION-REGISTRATION-STUDENT

Note that CourseID in the SECTION table should be a foreign key and thus dash-underlined in the table.

Turn in the SQL commands and the Relationship chart (press Alt + Print Screen key combination to copy-paste the chart into your Word file). (14 points) Problem 6-34, p.283, where the beginning words Write a database description means Write a SQL statement ... This problem requires you to

Problems and Exercises Problems and Exercises 6-34 through 6-44 are based on the class schedul ing 3NF relations along with some sample data shown in Figure 6-11 Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections. Note that values of the SectionNo column do not repeat across semesters. StudentID (integer, primary key) StudentName (25 characters) FacultyID (integer, primary key) FacultyName (25 characters) CourseID (8 characters, primary key) CourseName (15 characters) DateQualified (date) SectionNo (integer, primary key) Semester (7 characters) 6-34. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types STUDENT (StudentlD, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentID StudentName FacultylD CourselD DateQualified 38214 54907 66324 70542 2143 2143 3467 3467 4756 4756 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/2005 9/2005 9/2012 9/2013 9/2008 9/2008 er Altvater Aiken arra FACULTY (FacultylD, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultylID FacultyName SectionNo er CourselD 2143 3467- 4756 Birkin Berndt Collins 2712 2713 2714 2715 1-2015 I-2015 1l-2015 11-2015 ISM 3113 ISM 3113 ISM 4212 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentlD, SectionNo) CourselD CourseName StudentldD SectionNo

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Do Problems 4 and 5 using Microsoft Access. 4. (14 points) Problem 6-34, p.283, where the beginning words Write a database description means Write a SQL statement ... This problem requires you to...

Problems (60 points): 1. Transform each of the following ER or EER diagrams to a relational schema that shows referential integrity constraints and functional dependencies [see the Mapping Example...

need help for Question 1 and 2 of the assignment fir ACCT 221 FORENSIC BUSINESS INVESTIGATION. Pertains to WorldCom scandal. QAssuming WorldCom was a company operating in Australia at the time of the...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

CSC81002 Assignment 2 Weight:30% of your final mark Due:18 May 2020 11 pm Specifications Your task is to complete various exercises in BlueJ, using the Java language, and to submit these via the...

i have this homework, and those slides and files are related to this homework so we have to use them insoliving it please help me solving it as soon as possible ? 1. The city that your group is...

How many service representatives should be employed to meet the companys stated service goal for each time segment provided?

Johnson Company's details are given below regarding their cost of production. Using the information provided below, calculate: a. Break Even Point in units. b. If Johnson Company has a target of...

Assessment ( T 1 ) : Exploring New Opportunities ( 2 0 % ) This is a group assignment. As a group you will be required to look within belleville cape town for a business that is struggling and will...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

9. Describe the characteristics of power.

5. The month of Ramadan, a month of fasting for Muslims, ends with which holiday? a. Eid ul-Fitr b. Allahu Akbar c. Takbir d. Abu Bakr

2. What is the name of the dish that features black-eyed peas and rice (although sometimes collards, ham hocks, stewed tomatoes, or other items) and is served in the South, especially on New Years...