Question 7 You are given a list of courses that are currently available in BRACU that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EI 61','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate c masters students. Write a python program that creates a dictionary from the above list where the ke will be each department name (CSE,EEE,MAT for the above example) ar their values will be a dictionary of two keys Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively.

Question 7 You are given a list of courses that are currently available in BRACU that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EI 61','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate c masters students. Write a python program that creates a dictionary from the above list where the ke will be each department name (CSE,EEE,MAT for the above example) ar their values will be a dictionary of two keys Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively.

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

BIIT software house wants to maintain a database of its employees, projects assigned to employees and accounts. Database schema is given below.1- EMPLOYEE( eid, eName, eAge, eCity, eRank, eDep) 2- PROJECT ( pid, pName, pBonusAmout)3- Project_Allocation ( eid, pid)4- ACCOUNTS ( eid, Year, Month, Basic_Salary, Project_Bonus)5- ACCOUNTS_BACKUP( eid, Year, Month, Basic_Salary, Project_Bonus) 6- LOG( srNo, table_name , Date, Time, event, no_of_rows_effected) Perform following tasks a- Whenever a record is inserted or updated from ACCOUNTS table, it must also be inserted / updated in ACCOUNT_BACKUP table as well. Do not allow user to delete any record from ACCOUNTS or ACCOUNTS_BACKUP table. On insertion in ACCOUNTS table, Project_Bonus will be calculated by system on the basis of projects assigned to employee. b- Make sure primary foreign keys must not violate in any table. You must use triggers to apply any type of constraints. All keys are mentioned at the end. c- LOG table will maintain…
The following scenario is used for Case Projects 2-1 through 2-6: Darts is a sporting goods company with outlets in most of the western states. This company has a network of 10 servers and 273 client computers that have the following operating systems: Eight Windows Server 2012 servers Two Linux servers running Red Hat Linux Enterprise 20 computers running Mac OS X version 10.10 Yosemite 32 computers running Windows 10 80 computers running Windows 8.1 46 computers running Windows 7 12 computers running Windows Vista Darts realizes that with the projected growth of the company, they need to upgrade the computers and servers on their network. The new chief financial officer believes that the Windows 7 computers should not be upgraded. In his opinion, "If it works, don't fix it." What is your response?
(Q.17) Consider this functional dependencies {AB->C, BC->D, CD->E, E->F} Which of the following functional dependencies is/ are member of the given FD set? A) AB->F B) BC->A C) BC->E D) DEF->C Only the correct answer will be liked
Consider the situation in which two students are interested in enrolling in the same class but there is only place for one additional. How can a computerized registration system prevent one of the students from snagging the last open seat while the other waits?
Suppose we want to develop a browser-based training system to help people prepare for such a certification exam. A user can request a quiz for the system. The system picks a set of questions from its database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also examinators who must certify questions. List down the functional requirements of the above said system? Use Form based method for specifying “Make Quiz” functional requirement
How to normalise this realtion From 1NF to 3NF Employee( em_id,name, school_No, Name, Phone, Position, wage, Address) School (school_No,Address, size) Class(ClassID, Class_name, class_ Descrpt, teacher_id) Student (student_id, Name, Address, DOB, Phone , school_No) Teach(teacher_id, student_id) Take(classID, student_id) Payment (PaymentID, paymentDate,Amount, student_id) Teacher(teacher_id ,certificate , subject, school_No)
Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1. Given the preceding information, answer Questions a through e. How many database requests can you identify for an inventory update for both PRODUCT and PART? Using SQL, write each database request you identified in Step a. Write the complete transaction(s). Write the transaction log, using Table 10.1 as your template. Using the transaction log you created in Step d, trace its use in database recovery.
Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1.Given the preceding information, answer Questions a through e.a. How many database requests can you identify for an inventory update for both PRODUCT and PART?b. Using SQL, write each database request you identified in Step a.c. Write the complete transaction(s).d. Write the transaction log, using Table 10.1 as your template.e. Using the transaction log you created in Step d, trace its use in database recovery.
A city operates a set of tram lines. There are a number of stops for each tram line. For each tram line exactly one stop is the origin of the tram line and exactly one stop is the destination of the tram line. A terminus of a tram line is a stop that is either origin or destination of the tram line. 1)Model the tram system we just described in Alloy. Add signature facts when needed. Express each of the following constraints by an Alloy predicate: No two tram lines have the same stops Every tram stop is served by at least one tram line No two tram lines share the same terminus. 2) Write the following three functions: A function that returns all the tram lines serving a given stop A function that returns for two stops the set of tram lines serving both stops A function that returns, for two given tram lines, the set of stops that are served by both tram lines Add the notion of route to the above model: a route is defined for a tram line and consists of the (ordered) sequence of stops…
a. Which itemsets (of any length) are frequent if you know that {ace} and {ad} are the only maximal frequent itemsets? b. If all transactions that contain {bcd} also contain {def}, which of the following itemsets {bcd}, {def}, {bcde}, {bcdf}, {bcdef} are not closed?
How to normalise this realtion From 1NF to 3NF Employee( em_id,name, school_No, Name, Phone, Position, wage) school_no foreign key School_no—>transitive the address from school to employee , teacher,student School (school_No,Address, size) Class(ClassID, Class_name, class_ Descrpt, teacher_id) teacher_id foreign key Student (student_id, Name, DOB, Phone , school_No) school_no foreign key Teach(teacher_id, student_id) both foreign key Take(classID, student_id) both foreign key Payment (PaymentID, paymentDate,Amount, student_id) student_id foreign key Teacher(emp_id ,certificate , subject, school_No) emp_id foreign key school_No foreign key
The next best alternate after BCNF is 3NF. We can say that this schema is 3NF but not BCNF. Match the following statements that make this 3NF and not BCNF dept_advisor(s_ID, i_ID, dept_name) § With function dependencies: i_ID → dept_name s_ID, dept_name → i_ID § Two candidate keys = { s_ID , dept_name }, { s_ID , i_ID } - A. B. C. D. i_ID is not a superkey - A. B. C. D. { dept_name} – {i_ID } - A. B. C. D. dept_name is contained in a candidate key - A. B. C. D. s_ID, dept_name A. {dept_name } B. Since each attribute A in β – α is contained in a candidate key for R, dept_advisors is 3NF C. superkey D. dept_advisor is not BCNF

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning