Microsoft Access Database Design Basics?

Question

I am a college student and in turn I slept through a very important day covering Microsoft Access database design in my Computer Sciences class, this is what he gave me:

Use MS Access to create the database design shown below:

suppliers table

(sno char(3) primary key,

sname char(15),

status numeric,

city char(10));

parts table

(pno char(3) primary key,

pname char(15),

color char(10),

weight numeric,

city char(10));

orders table

(sno char(3) combined primary key of sno and pno,

pno char(3) foreign keys sno and pno – use the relationships screen to set up these foreign keys,

qty numeric);



Add the data shown below to the indicated tables:

suppliers table

('S1','Smith',20, 'London');

('S2','Jones',10, 'Paris');

('S3','Blake',30, 'Paris');

('S4','Clark',20, 'London');

('S5','Adams',30, 'Athens');

parts table

('P1','Nut','Red',12, 'London');

('P2','Bolt','Green',17, 'Paris');

('P3','Screw','Blue',17, 'Rome');

('P4','Screw','Red',14, 'London');

('P5','Cam','Blue',12, 'Paris');

('P6','Cog','Red',19, 'London');

orders table

('S1','P1',300);

('S1','P2',200);

('S1','P3',400);

('S1','P4',200);

('S1','P5',100);

('S1','P6',100);

('S2','P1',300);

('S2','P2',400);

('S3','P2',200);

('S4','P2',200);

('S4','P4',300);

('S4','P5',400);

Create a query, a form and a report of your choice (using two of the related tables for each). Add your name to the headers for the form and report that you create.


Entering the data shouldn't be any problem for me but I have no clue what to do with those figures at the beginning where it says (sno and other weird stuff, I would be indebted to whoever could tell me what to do with these and or give me a reference or good resource.

Answer 1

Ok...see if I can break this down for you.



Under the heading of Suppliers table, they gave you 4 entries - these are the 4 fields they want in the table. The first thing is the name, then what type of data is in there, and the length of the field. For instance "sname char(15)" means create a field named "sname" - probably short for Supplier Name - that is 15 characters long. Where it says Primary Key - this is the field they want to set as the Primary Key for that table.



I've added a link that gives the basic steps for creating a table

Answer 2

The first part tells you what tables you need and what columns each table will have. "sno" is short for "Supplier Number" and will be the primary key. For each part, the first word is the column name and the second word is the information type.



Note that in the Orders table, you have a concatenated primary key where both sno and pno together are the primary key and they are both foreign keys (hopefully you understand what that means and didn't sleep through that part).

Answer 3

you may click on "sparkling database". utilizing the Database wizard might initially help you, even though, you're constrained while attempting to enforce the database for the job meant. as an occasion, you may create a database on your telephone and handle e book, even though in case you probably did no longer capture all the fields on your first flow-around, you won't be waiting to apply the database to merge right into a MSWord checklist. get admission to is an exceedingly solid application, even though it does take some getting used to. The library might have some manuals which will help you get all started.