Answer to Question #46235 in Programming & Computer Science for Andre

Question

Design the database for a programming support environment. In this environment programmers produce programs, which are written in given programming languages. Each program is written by a given programmer, can call other programs, and can be used by given users. Users are recognized by their log-in names. Programmers are recognized by their log-in name and by their code. Programs have compound names that include the program’s name, the extension and the programmer’s code. Programs have a version number, a date and a short description; some programs interact with DBMSs. Each DBMS maintains stored data in the form of relations, with several attributes and one primary key. Each database is defined by a database administrator, who is a programmer specialized in data management. State clearly any assumptions you make.

Required
(a) Construct an ER diagram from the description above.