Conceptual and Logical Design

Conceptual and Logical Design


(a) Draw an ER diagram according to the list of requirements given below.

(b) Convert your ER diagram to a relational database schema.

Deliverables: ER diagram and relational schema. Hand-written scanned documents will NOT be accepted, please use the drawing tools(Dia Diagram Editor).

Design a code-versioning system (CVS) database for a software development company based on the following requirements.

• Every user has a name, multiple e-mails and a unique username.

• Every software project developed by the company is referred to with a unique name and

version combination. Together with this information, the following data of a project

are stored:

(a) a textual description of the project and,

(b) the root directory (that contains documents related with the project).

• Documents are identified by their absolute path.

• Every document has exactly one owner, who is a user. Document ownership is established upon document creation and the timestamp of this event is kept in the database

explicitly. Ownership can later be transferred but the “date created” property of a

document cannot be modified.

• The database does not keep any history of document ownership. Only the current

owner information is maintained.

• Every project contains at least one document. However some documents may not be

contained in any project, such as personal files.

• Users contribute to multiple projects. For each user working on a project, the user’s

contribution start-date and end-date are stored. Assume that once a user stops working

for a project, he/she cannot work for the same project again. Therefore, there is only

one start-date for each user working on each project.

• The database also keeps the duration of time each user worked on a project. Notice

that this value can b e calculated easily based on the start-date and end-date fields

described above.

• Every project is coordinated by a user. A co ordinator may co ordinate multiple projects


• The most important part of the database contains access logs of users. Whenever a

user accesses a document, an access log entry is created by the system.

• Each access log entry contains the following information:

(a) type of access: either ‘R’ for read, or ‘W’ for write, ‘RW’ for read and write,

(b) event timestamp: the date and time when the user accessed the document, and,

(c) a field called “difference”.

• The field “difference” is textual (i.e., is a string) and contains all the details needed

for undoing an edit operation by a user. Think of this field as an incremental backup

of the document.

• Over time, it is natural that a user will have multiple access log entries for a document.

• However, a user cannot have two access log entries on the same document with the

same timestamp.

Do not assign auto-increment type of keys to any of the entities.

Compétences : Développement de bases de données, Programmation de bases de données

en voir plus : tools needed for programming, schema design, property development company, programming diagram, logs design, logical programming, history of programming, event based programming, c programming absolute value, access database design programming, access database design and programming, er diagram to relational schema, drawing design software, software design documents, r programming project, logical no, ER diagram, e/r diagram, convert this drawing to, conceptual

Concernant l'employeur :
( 6 commentaires ) Finder, Turkey

Nº du projet : #7449866

10 freelance font une offre moyenne de $52 pour ce travail


Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)

Hi. I am professional database developer. I am able to do all your requirements. I have a lot of experience in similar projects. Check my profile. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)

Hello, I have been working with a MNC bases company since last ~ 4 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)

I am a talented Developer with years of experience and educational training. I have also worked for many years of my career as a ASP.NET/EF5 . If hired by you I will deliver my best work at a high standard. I look fo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Dear Sir/Madam, I have a vast experience in Database Development,Sql,Oracle,java, Asp.Net.C#, and C. Above all i am computer Engineer and currently i am working as a software developer in a private company,So i co Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

current model (physical,logical and conceptual model ) and implement databases sql server and oracle

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

I am expert in relational database. I have sound experience on this subject. I have understood your needs of project. I'll do this project for you in an efficient way. First I'll cover schema and ERD then i will cove Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(0 Commentaires)

Can be delivered in 3 days. I have MS degree with specialization in databases and i am being in programming from last 10 years.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)