Dear Student ,
As per the requirement submitted above , kindly find the below solution.
This demonstration is using SQL Server 2014.
Question a:
create table Student(
StuNo varchar(10) primary key,
StuName varchar(50)
);
create table Subject(
SubCode varchar(10) primary key,
SubName varchar(50)
);
create table Enrolment(
StuNo varchar(10),
SubCode varchar(10),
Garde char(1),
primary key(StuNo,SubCode)
);
****************************
Question b:
******************************
Question c:
insert into student values('STU101','Henry Bloggs');
******************************
Question d:
insert into subject values('INF10004','Database Analysis and Design');
******************************
Question e:
insert into Enrolment (StuNo,SubCode) values ('STU101','INF10004')
***************************
Question f :
update Enrolment set Garde='N' where StuNo='STU101';
****************************
Question g :
update Enrolment set Garde='D' where StuNo='STU101';
************************************
Question h :
NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.
1. Consider the following ER diagram. Stung StuName Grade SubCode SubName STUDENT has an ENROLMENT >...
Problems and Exercises 1 through 9 are based on the dass scheduling
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.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student
table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...
1 pts Based on the following ER Diagram from the database called "Student Financial." What SQL statement would you use to answer the following question? Student Tuition PKPSUID PK tutionID FirstName Pays (1.1-FX Student LastName SemesterCost Email Scholarships Department DueDate What are the names of all departments that contain the word "art" in them? (Provide a list of departments, no repeats) SELECT [Select] FROM Student WHERE [Select) Based on the following ER Diagram from the databa "Student Financial." What SQL...
Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For
Problems and Exercises 1 through 5, draw a Venn or ER diagram and
mark it to show the data you expect your query to use to produce the
results.Figure 7-16: Class scheduling relations (for Problems and Exercises 1-5Figure 7-17 Adult literacy program (for Problems and Exercises 6-14)1. Write SQL retrieval commands for each of the following
queries:a....
1. Using the STUDENT table structure shown in Table P6.4, do the following. Table P6.4 Sample STUDENT Records Attributes Name Sample Value Sample Value Sample Value Sample Value Sample Value STU_NUM STU_LNAME STU_MAJOR DEPT_CODE DEPT_NAME DEPT_PHONE COLLEGE_NAME ADVISOR_LNAME ADVISOR_OFFICE ADVISOR_BLDG ADVISOR_PHONE STU_GPA STU_HOURS STU_CLASS 211343 stephanos Accounting ACCT Accounting 4356 Business Admin Grastrand T201 Torre Building 2115 3.87 75 junior 200128 Smith Accounting ACCT Accounting 4356 Business Admin Grastrand T201 Torre Building 2115 2.78 45 Sophomore 199876 Jones Marketing MKTG...
The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...
PROBLEM STATEMENT: Suppose you have a client that has given you
the following business rules to form the basis for a database
design. The database must enable the manager of a company dinner
club to mail invitations to the club’s members, to plan the meals,
to keep track of who attends the dinners, and so on. Each dinner
serves many members, and each member may attend many dinners. A
member receives many invitations, and each invitation is mailed to
many...
Suppose a student is taking IS 620 section 1 and HCC 629 section 1 for spring 2019. Use an explicit cursor to print out the titles and prices of textbooks for these two courses. Sample code to create the tables: drop table textbook_schedule cascade constraints; drop table textbook_author cascade constraints; drop table schedule cascade constraints; drop table course cascade constraints; drop table textbook cascade constraints; drop table author cascade constraints; drop table teacher cascade constraints; drop table program cascade constraints;...
1) Create Conceptual Schema Diagram
2) Create a fully attributed Loagical Data Model Diagram
3) Create the SQL script that will generate the data model
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...
Question 1.Write a SQL statement for each of the following
questions based on the above tables (50 Points).
1) Create “Enrollment” table.
2) Change the credits of “Database” course from 2 to 3.
3) List the course titles (not Course_No) and grades John Doe
had taken.
4) Calculate average of Café Balance, and name new field as
Average Balance.
5) Create a roster for “Database” course (list student ID, last
name, first name, major, and status for each student enrolled...