Take once again a detailed look at the ER diagram of the CMS from the section called “Introduction to Database Terms”. Now think of a way to introduce a context specific navigation to the pages. The general navigation is at the left of my proposed display. The context specific could be across the top of the content area in the pages linked to by the the general navigation. Make an ER diagram reflecting the changes you propose. Write a few words to argue your decisions.
Create a model of a database that must hold the employees and departments of a small company. The employees do not split between departments, but work in one only. What attributes do you think are necessary? Discuss the prerequisites and choices you make.
Model a database for a system for book publishers. The publishera have contracts with a numbers of authors. The authors write the books. Discuss the prerequisites and choices you make.
Create an ER model of a ministry of education. The ministry coordinates several institutions in the shape of commercial and technical colleges as well as academies. The colleges have professional degree programs of the shorter kind, 2 years. The academies have shorter programs as well as bachelor programs. The database must be able to supply information such as: Who is the responsible coordinator for institutions in any given city or area? Who is the coordinator responsible for any given program? What are their contact addresses and phone numbers. Use your imagination and figure out what the relevant attributes are. Discuss the prerequisites and choices you make.
Model a database for the orders system of a small company. We have the possibility of ordering online. An order is registered and triggers an order confirmation showing items, numbers, unit prices at the time order entry. In addition the confirmation issues an estimated delivery date. Discuss the prerequisites and choices you make.
You have an earlier model of a database from the census bureau. It holds information about marriages. Expand that model in this assignment. Refer to the section called “Assignment 1.2”
The system must also be capable of showing who were divorced during the year. This is also relevant for the calculation of taxes.
The system additionally be able to produce a list of minors, under 18 years of age. We want to know who the father is, who the mother is, and whether the children are 'legitimate' or not. The latter is relevant for inheritance etc.
Finally find a way of modelling date of death without allowing nulls.
We want a model af a database that is capable of being part of a course administration system. We need student lists, class member list. Class member lists must have the name of the course, the start and finish date, email adresses etc supplementing of course names and addresses.
The system must facilitate recording presence at classes for all members of any class.