1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Marta_Voda [28]
4 years ago
10

Consider the university enrollment database schema: 547 Student(snurn: integer, snarne: string, majoT: string, level: string, ag

e: integer) Class( name: string, meets_at: time, Toom: string, fid"' integer) Enrolled(snum: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer) The meaning of these relations is straightforward; for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. For each of the following transactions, state the SQL isolation level you would use and explain why you chose it.
1. Enroll a student identified by her snum into the class named 'Introduction to Database Systems'.
2. Change enrollment for a student identified by her snum from one class to another class,
3. Assign a new faculty member identified by his fid to the class with the least number of students.
4. For each class, show the number of students enrolled in the class.
Computers and Technology
1 answer:
trapecia [35]4 years ago
8 0

Enroll a student identified by her snum into the class named 'Introduction to Database Systems' is the following transactions, state the SQL isolation level you would use.

1. Enroll a student identified by her snum into the class named 'Introduction to Database Systems'.

<u>Explanation:</u>

Since enroll is unique in the university enrollment database schema and field name is SNUM and it is data type is an integer. To identify student class name and department name and name of student SNUM field is used for searching in university enrollment database schema. Enrollment changing is not possible of the student’s not possible or not good practices in university enrollment database schema.

If a query had been made class wise or department wise enrollment is played an important role.

For  assign, a faculty is made on the class id or  department id.

You might be interested in
As more and more computing devices move into the home environment, there's a need for a centralized storage space, called a ____
Ksivusya [100]

Answer: Network attached storage device

Explanation:

Network attached storage(NAS) is the data storage server device that is responsible for serving files to configuration and other components.Through this sever device data can be retrieved by various client and user from central disk capacity .It provides good data access to diverse user and client of data.

  • Other options are incorrect because RAID drive, server station, gigabit NIC are not the devices that centrally store huge amount of data for access.
  • Thus, the correct option is network attached storage(NAS) device

8 0
3 years ago
How long is prison time for someone who commits copyright infringement for the first time ?
Murljashka [212]

Answer:

it is up to 5 years

Explanation:

7 0
3 years ago
Assume that the string oldSeq has been properly declared and initialized and contains the string segment. Write a code segment t
son4ous [18]

String oldSeq="1100000111";

String segment="11";

String newSeq=oldSeq.replaceFirst(segment, "");

7 0
3 years ago
Five uses of the start button
Damm [24]

Starting something

Possibly turning it off

Making something work

Fixing the Start Button

Beginning something

5 0
3 years ago
You can press and hold [Tab] and click the Normal button on the status bar to display the slide master.
tester [92]

Answer:

False.

Explanation:

No, By pressing and holding tab and clicking the normal button on the status bar will not help you in opening the slide master. By holding the shift key and pressing the first icon as shown in this figure will open the slide master for you.

5 0
3 years ago
Read 2 more answers
Other questions:
  • Write a function decimalToBinaryRecursive that converts a decimal value to binary using recursion. This function takes a single
    11·1 answer
  • What is meaning of reboot
    7·2 answers
  • When would you use a template when working with word 2013?
    15·1 answer
  • What are the benefits of maintaining you vehicle?
    11·1 answer
  • What does it mean when a computer can't break the rules
    10·2 answers
  • What feature, new to Windows Server 2012, provides the ability to find identical sets of data on a SAN-based storage array and r
    13·1 answer
  • Which one of these is NOT an indicator that an email is spam?
    5·1 answer
  • 3 uses of Microsoft word in hospital
    10·1 answer
  • 2.3 Code Practice: Question 1
    5·1 answer
  • Write a program that reads a list of integers into a list as long as the integers are greater than zero, then outputs the smalle
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!