Conceptual and Logical Design

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

Conceptual and Logical Design

Steps:

(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

concurrently.

• 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.

Розробка баз даних Програмування баз даних

ID Проекту: #7449866

Про проект

10 заявок(-ки) Дистанційний проект Остання активність May 17, 2015

10 фрілансерів(-и) готові виконати цю роботу у середньому за $52

acronymsolutions

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, Більше

$75 USD за 3 дні(-в)
(12 відгуків(и))
4.2
boscha

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

$45 USD за 3 дні(-в)
(6 відгуків(и))
3.0
ashishseth1988

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 Більше

$35 USD за 1 день
(7 відгуків(и))
3.0
saidmohamed11

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 Більше

$55 USD за 2 дні(-в)
(1 відгук)
1.0
jameskaikai

A proposal has not yet been provided

$50 USD за 3 дні(-в)
(0 відгуків(и))
0.0
shazadakram

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 Більше

$40 USD за 3 дні(-в)
(0 відгуків(и))
0.0
deepakmishra1988

A proposal has not yet been provided

$35 USD за 3 дні(-в)
(0 відгуків(и))
0.0
ingeniosito

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

$34 USD за 3 дні(-в)
(0 відгуків(и))
0.0
goharjavaid15

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 Більше

$111 USD за 25 дні(-в)
(0 відгуків(и))
0.0
Javagurupk

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

$35 USD за 3 дні(-в)
(0 відгуків(и))
2.4