DA Morgan <damorgan_at_x.washington.edu> wrote in
news:1106842617.933021_at_yasure:
> Mintyman wrote:
>> Hi there,
>>
>> I am VERY new to SQL server but need to create a relational database.
>> I was hoping if i explained in layman's terms what I need to try and
>> do, some kind person could help me out. So , here goes....
>>
>> I have a table of products (serial number is the primary key,
>> description and a product category). Each machine has at least 1 PCB
>> inside it, maybe more. Each PCB has a PCB_No (e.g. PCB_001, a
>> description, some software and a revision number (e.g. 1.1). Each PCB
>> can have more than 1 revision, so there could be 2 instances of
>> PCB_001, one with revision 1.0 and another with 1.1. Also, each PCB
>> can also have different software on it telling it what to do.
>>
>> Can anyone show me what each table would look like and how the
>> relationships between the tables would be made? I would be VERY
>> grateful.
>>
>> TIA,
>>
>> Darren
>
> Hopefully not. You are taking a data modeling class and this is your
> homework ... not their. The appropriate thing to do is have a private
> meeting with the intructor or meet with one or more of the other
> students in the class.
>
> If we just hand it to you ... you learn nothing.
DA Morgan ... why do you even bother posting? This seems to be a
recurring theme with your posts. I've read a couple of your posts where
you justify not helping beginners by claiming that they are trying to
cheat on homework. What proof do you have? I've got news for you. The
majority of people in systems and network administration do not have a
formal computer science college background or cetification training
before they begin learning a topic. Many people, because of skills they
have in another related area, assume responsibility over an area and have
to learn a topic from scratch. The read books, magazines, mailing lists,
and newsgroups. Some post to mailing lists or newsgroups. By posting
accusations like this, you are impeding legitimate beginners. If your
goal is to leave the database and oracle newsgroups as the realm of the
certified and experienced, then you are doing a fine job.
Received on Fri Jan 28 2005 - 19:13:22 CST
