3 Replies - 384 Views - Last Post: 27 November 2013 - 11:41 AM Rate Topic: -----

#1 ammaar12  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 28
  • Joined: 21-September 13

Entities and Attributes in this Question?

Posted 27 November 2013 - 08:39 AM

Hello Everyone,

So, for the question given below. I've been able to find out the Entities which are emphasized in bold and their attributes as Italic. And the points number (3) and (5), I think that they are relationship types between PC and Employee, and PC and Software Packages. Is that correct? I'm not able to figure out the attributes in these points as to where to add them. Thanks in-advance...

PC Associates is a large, multinational consulting corporation, which uses a number of PCs and software packages in the course of her work. PC Associates needs to maintain the following information about the PCs and software packages its employee uses to do their jobs.

1) For each PC, the computer number, the computer model and manufacturer, and the type of microprocessor needed to be stored.

2) Data for each employee also needed to be stored - such as the employee name, employee number, and phone number.

3) Also for each PC, the inventory tag number, location, computer number and the number of the employee who owns the PC.

4) For each software package, the package number, current cost, type, name and version needed to be stored.

5) Also for each software package installed on a PC, the package number and cost, installation date and inventory tag number needed to be stored.

Is This A Good Question/Topic? 0
  • +

Replies To: Entities and Attributes in this Question?

#2 Bitcoder  Icon User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 5
  • Joined: 27-November 13

Re: Entities and Attributes in this Question?

Posted 27 November 2013 - 09:03 AM

You got it right. It should look like this.

Note that a "field" is also synonymous with "attribute"
Table name: PC

Fields DataType
Computer number Text
Computer model Text
Manufacturer Lookup
Microprocessor Lookup


Table name: "Employee"

Fields DataType
Employee Name Text
Employee Number If you are using MsAccess then an AutoNumber datatype should do make it the primary key
Phone Number Text


Table name: "Software package"

Fields DataType
Package number primary key
Current cost Currency
Name Text
Version text


hold on for outline 3 and 5

You got it right. It should look like this.

Note that a "field" is also synonymous with "attribute"
Table name: PC

Fields DataType
Computer number Text
Computer model Text
Manufacturer Lookup
Microprocessor Lookup


Table name: "Employee"

Fields DataType
Employee Name Text
Employee Number If you are using MsAccess then an
AutoNumber datatype should do make
it the primary key
Phone Number Text


Table name: "Software package"

Fields DataType
Package number primary key
Current cost Currency
Name Text
Version text


hold on for outline 3 and 5
Was This Post Helpful? 1
  • +
  • -

#3 Bitcoder  Icon User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 5
  • Joined: 27-November 13

Re: Entities and Attributes in this Question?

Posted 27 November 2013 - 09:22 AM

back to #3

thou I don't get what you try to explain but this is what I suggest

on #3 the following fields exist

'Tag number'

which belongs to the inventory table because you used 'Inventory tag number'

'Location'
make a lookup of all the locations in the company

'computer number'
which belongs to the PC table

and the last part 'the number of the employee who owns the pc do you mean the 'employee number'?

well if am right

then

'Employee number'

which belongs to the employee table

the problem now is should you create a table for this well I think that wouldn't be right

you need smart SQL to pull all these field from different table and you get a result-set with the following fields.


hope you find my post useful?
Was This Post Helpful? 1
  • +
  • -

#4 ammaar12  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 28
  • Joined: 21-September 13

Re: Entities and Attributes in this Question?

Posted 27 November 2013 - 11:41 AM

Yap it was quite useful, thanks mate..

I use SQLPlus, so at first we gotta make ER diagram, den relational database and then Tables in the SQL.. Hope it will be done correctly.. Anyways, thanks alot :) Well-appreciated.. If any assistance required, i'll keep updating this forum..
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1