Write a Python sqlite3 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 ...

Write a

Python sql
ite3

based

program that stores names and dates of birth in a databas
e.

The

establis
hed 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 t
est programs to

prove that

this

system catalog

i
s

accessible to external users.

2.

Create an ER model for

each of the following descriptions:

a)

Each company operates four departments, and each department belongs to one company.

b)

Each department in part (a) employs one or more employees, and each employee works for

one department.

c)

Each of the employees

in part (b) may or may not have one or more dependents, and each

dependent

belongs to one employee.

d)

Each employee in part (c) may or may not have an employment history.

e)

Represent all the ER models described in (a), (b), (c), and (d) as a single ER

model.

3.

Assume you have been contracted by a university to develop a database system to keep

track of student registration

and accommodation records. The university courses are offered

by faculties. Depending on the student’s

IQ, there are no limitat
ions to how many courses a

student can enroll in. The faculties are not responsible for

student accommodation. The

university owns a number of ho
s
tels and each student is given a shared room key

after

enrollment. Each room has furniture attached to it.

a)

Identify the main entity types for the project.

b)

Identify the main relationship types and specify the multiplicity for each relationship. State any

assumptions

that you make about the data.

c)

Using your answers for (a) and (b), draw a single ER diagr
am to represent the data

requirements for the project.

Oct 20, 2022

SOLUTION.PDF

Write a Python sqlite3 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 ...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment