Csc. Please help check th 1st Q
1 answer:
You might be interested in
Answer:
For designing a database suitable for a University registrar, the following information is included which are Information about Students, Information about Departments, Information about Professors, Information about courses, Student Grades,TA's for a course, Department offering different courses.
In creating the database registrar system the following values are defined such as Entity, Attributes of entities,The relationship among entities.
Explanation:
Solution
The following requirements are for designing of database for a University registrar.
The Database Schema includes the following:
- Information about Students
- Information about Departments.
- Information about Professors.
- Information about courses.
- Student Grades.
- TA's for a course.
- Department offering different courses.
Now,
For the design of Database for Registrar System we need to define the following:
(1)Entity: Student, Course, Instructor, Course offering.
(2) Attributes of Entities:
- Student entity has Sid, name, program as its attributes
- Course has Course_n, title, credits, and syllabus as its attributes
- Instructor has iid ,name ,dept, title as its attributes
- Course offering has section_no ,time, room, year,semester as its attributes
(3) Relationship among various entities:
- Enrolls
- Teaches
- © is offered
Note: kindly find an attached copy of the E-R Diagram for University Registrar below, and his diagram shows student entity enrolls various courses which can be having teaches relationship with instructor. Course is being offered by relationship is offered by course offering.
Answer:
Explanation:
The following code is written in Python. It is a function called checkString that takes in a string as an argument and loops through each char in that string and checking to see if it is lowercase, uppercase, vowel, consonant, or punctuations. It adds 1 to the correct variable. At the end of the loop it prints out all of the variables. The picture below shows a test output with the string "Brainly, Question."
def checkString(word):
uppercase = 0
lowercase = 0
vowel = 0
consonants = 0
punctuation = 0
vowelArray = ['a', 'e', 'i', 'o','u', 'y' ]
consonantArray = ['b', 'c', 'd', 'f', 'g', 'h', 'j', 'k', 'l', 'm', 'n', 'p', 'q', 'r', 's', 't', 'v', 'w', 'x', 'y', 'z']
punctuationArray = ['.', '!', '?', ',', ';', '(', ')']
for char in word:
if char.isupper():
uppercase += 1
else:
lowercase += 1
if char.lower() in vowelArray:
vowel += 1
elif char.lower() in consonantArray:
consonants += 1
if char in punctuationArray:
punctuation += 1
print('Uppercase: ' + str(uppercase))
print('Lowercase: ' + str(lowercase))
print('Vowels: ' + str(vowel))
print('Consonants: ' + str(consonants))
print('Punctuations: ' + str(punctuation))
