Notation of Business Rules (1 Viewer)

[lance7tour]

InstructorName, LocationName, LocationAddress, LocationCity, LocationState, LocationZip, DateInstructor, AssignedToLocation, CourseNumber, CourseName, CourseSection, Number, Credits, SemesterOffered

Was given the above fields n an xls spreadsheet with these accompanied business rules:

1 Each location can have more than one instructor
2 Each instructor can teach at more than one location.
3 Each course has one name
4 A course is always worth the same number of credits
5 A course can have many sections
6 Each section has a unique section number. These numbers are never reused.
7 Each location offers many course sections
8 Each course section is offered at a single location
9 Each location has one address
10 Course sections are assigned to locations, not instructors

Am new to access and am supposed to take each rule and write out the notation describing the rule needed but I have no clue on where to start or how to accomplish this.

any help would be appreciated

 

[jdraw]

Read the first few topics---normal forms, normalisation and Entity Relationship Diagramming--- at
http://www.rogersaccesslibrary.com/forum/topic238.html

 

[lance7tour]

am still confused on what i am supposed to do accroding to the business rules and the xls spreadsheet

 

[lance7tour]

This is what i finally got from the instructor ref. the business rules and what we are supposed to do.

"You are only supposed to write out the DBDL plan for the database, not actually make any tables. Your finished product should be similar to the sample I just sent you. n this class, it's all about the planning part. In the next class, DB Apps, is where you build the database. So, look over the sample data and the business rules and give it a shot."

This is what she sent me as examples:

tblStudents (StudentID, FName, LName, MI, SSN, BirthDate)

tblClasses (ClassID, Name, CatNum, Credits, Description)
SK Name

tblClassSections (ClassSectionID, Location, Semester, Instructor, ClassID)

tblStudentClassSections (StudentID, ClassSectionID, DateEnrolled, Grade, Notes)

So with that being said how do the business rules with the said labels from xls spreadsheet make what she is requesting.

thanks

 

[jdraw]

What the info you have is saying is

We have Students and Classes.
Classes are broken down into Sections
A Class has an Identifier, Name, a CatNum, is worth so many credits, and has a description.
A ClassSection has an identifier, takes place at a Location, occurs in a semester, has an Instructor and is related to a Class.
A Student attends a ClassSection.

etc....
Your first post had the details, but you know the course/instructor, so was he asking for a data model, or more info about relationships??

THere is more info here that may be suitable to you.
http://www.databaseanswers.org/data_models/student_class_scheduling/index.htm and
http://www.databaseanswers.org/data_models/student_class_scheduling/facts.htm

I don't know what level you are working at, but here is more formal info about business rules gleaned from Google.
http://www.businessrulesgroup.org/first_paper/br01c1.htm

 

[lance7tour]

She is saying that I have to take the below and make into DBDL plan (i.e. below is what she sent me as an example of what she is looking for, for each business rules)

tblStudents (StudentID, FName, LName, MI, SSN, BirthDate)
AK SSN
SK LName
tblClasses (ClassID, Name, CatNum, Credits, Description)
SK Name
tblClassSections (ClassSectionID, Location, Semester, Instructor, ClassID)
FK ClassID à tblClasses
tblStudentClassSections (StudentID, ClassSectionID, DateEnrolled, Grade, Notes)
FK StudentID à tblStudents
FK ClassSectionID à tblClassSections
InstructorName, LocationName, LocationAddress, LocationCity, LocationState, LocationZip, DateInstructor, AssignedToLocation, CourseNumber, CourseName, CourseSection, Number, Credits, SemesterOffered

Was given the above fields n an xls spreadsheet with these accompanied rules:

1 Each location can have more than one instructor
2 Each instructor can teach at more than one location.
3 Each course has one name
4 A course is always worth the same number of credits
5 A course can have many sections
6 Each section has a unique section number. These numbers are never reused.
7 Each location offers many course sections
8 Each course section is offered at a single location
9 Each location has one address
10 Course sections are assigned to locations, not instructors
anyway she isnt the greatest at explaining nor dictating what the assignment is for.