Question: a) b) c) d) e) a) b) c) Write a Python sglite3 based program that stores names and dates of birth in a database. The

a) b) c) d) e) a) b) c) Write a Python sglite3 based program that stores names and dates of birth in a database. The established database includes at least 5 rows. Extend the program so that it stores the format of the data in the database: in other words, create a system catalog. Write test programs to prove that this system catalog is accessible to external users. Create an ER model for each of the following descriptions: Each company operates four departments, and each department belongs to one company. Each department in part (a) employs one or more employees, and each employee works for one department. Each of the employees in part (b) may or may not have one or more dependents, and each dependent belongs to one employee. Each employee in part (c) may or may not have an employment history. Represent all the ER. models described in (a), (b), (c), and (d) as a single ER model. Assume you have been contracted by a university to develop a database system to keep track of student registration and accommeodation records. The university courses are offered by faculties. Depending on the student's 1Q, there are no limitations to how many courses a student can enroll in. The faculties are not responsible for student accommedation. The university owns a number of hostels and each student is given a shared room key after enrollment. Each room has furniture attached to it. Identify the main entity types for the project. Identify the main relationship types and specify the multiplicity for each relationship. State any assumptions that you make about the data. Using your answers for (a) and (b), draw a single ER diagram fo represent the data requirements for the project
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
