Using the Fuzzy Logic Interview discussion board, produce a mapping from the interview to a series of business rules. Remember, business rules should always be two-sided as they in turn map to entities and their relationships. For example, if you have multiple employees that work in a department, your business rule might state:

A DEPARTMENT employs zero or more EMPLOYEEs. An EMPLOYEE works in one and only one DEPARTMENT.

In this example, note:

a) I state zero or more on the "employs" part of the relationship instead of many. By doing so you know that the EMPLOYEE side is optional, i.e. a DEPARTMENT may have no employees assigned. If I had stated "A DEPARTMENT employs one or more EMPLOYEEs", then I would know that the EMPLOYEE is mandatory, i.e. the department must contain at least one employee.

b) Note that the 2nd sentence is NOT a repeat of the first sentence. If you were drawing these in Crow's foot notation, and you had a DEPARTMENT entity on the left and a EMPLOYEE entity on the right, the first sentence tells you that you would have a crow's foot on the EMPLOYEE side of the relationship line (along with the O to mark it optional). The 2nd sentence tells us what goes on the other side (i.e. on the DEPARTMENT side of the line). Since we have "one and only one" DEPARTMENT for the given (An) EMPLOYEE, it tells use that the left side of the notation would be a || (indicating one and only one), i.e.that DEPARTMENT is mandatory for an EMPLOYEE. The two statements TOGETHER tell us that DEPTMENT to EMPLOYEE is 1:M.

c)You could also show the Business rule as:

A DEPARTMENT employees many EMPLOYEES.

A DEPARTMENT may have no EMPLOYEES.

An EMPLOYEE works in a DEPARTMENT.

An EMPLOYEE must have a DEPARTMENT assigned.

I will accept this (but I don't like it as much as it requires four sentences to convey the same information content).

The specific format you use is up to you. However, you need to ensure that you

1) Enumerate the Interview questions and answers (i.e. copy/paste the discussion board content to a word doc and number the Q/A so that you can refer to a question/ answer by number)

2) Show a mapping from the interview to the Business Rules. For example, you can either list the business rule # for each discussion board post (or set of posts), or list the discussion board post (or set of posts) enumerated in 1) when you itemize the business rules.

3) If there are interview statements that do not map to a Business Rule, state so. You may determine that certain Q&A provide constraints (in which case you can mark it so). You may also determine that you have additional Business Rules that are required for which you don't have information from the interview. In this case, mark these as an assumption.

FUZZY LOGIC INTERVIEW DISCUSSION BOARD

Q: How many employees at a time work at a terrestrial station? What about the Internet station? Does the number of employees at a certain station vary depending on the time of day?

A: The number of employees working at one time can vary (both for terrestrial an Internet). Yes, the number can vary based on the time of day.

Q: How is revenue generated from each radio station or Internet?

A: Revenue is generated by playing ad's. That is, the playing of an Advertisement is tracked and needs to result in the advertiser being billed.

Q: Do the employee created their own playlist or is mandatory across and stations?

A: Playlists are created by DJ's (employees) but can be shared by other DJ's (employees) and used on other stations. It is possible to have mandatory playlists, currently that is left up to the individual station but is an interesting idea.

Q: What is the length duration limit of a single playlist? (This is to determine constraints for the PLAYLIST entity, and I assume that each PLAYLIST needs a time limit so that advertisements can be played)

A: In practical terms, playlists typically are limited to the length of a show. Why can't the play list include advertisements? Aren't advertisements just a stream of bits similar to music being played? (hint hint) We would hope that this great data base model you are doing for us would easily handle changes to a max length, e.g. having a playlist that would run for a whole day or maybe even multiple days!

Q: For the Internet station, are employees needed to run it? Or can the station exist without an employee?

A: Well, an employee needs to set up one or more playlists and must "play" the playlist. That doesn't mean they spin records (like in the old days), so it is somewhat automated.

Q: Do they track on location events? (ex: Car dealerships, fairs, special events, concerts, etc.)

If yes, is there a limit to the number of employees that would cover it?

A: Who is 'they'? Yes, we sometimes broadcast from other locations. The number of employees working depend on the event.

Q: You had mentioned earlier that revenue that is generated comes from playing ads, and you folks keep track of it.

How would you keep track of them? Do you prefer us to create tracking system? Do you have minimum or maximum number of ads playing in each day?

A: We need to log all ad play, so we can charge back to the advertiser. We need to log all music play, so we can pay appropriate royalties. We need to keep track of when something is played, on what station it was played, and by whom. We charge advertisers based on the where/when. For royalties, it currently doesn't matter in terms of the when but does matter on the where (e.g. terrestrial vs Internet), but we would like the model to be flexible in terms of each of these factors.

Q: How are staff paid - hourly or salaried? What are the min/max staff earnings ranges? ex: ($10,$50) per hour)

A: We have both hourly and salaried employees. The earning ranges are proprietary

Q: How do you current track employees clocking in, breaks, lunches and clocking our? .

A: Yes, employees need to check in and check out. We would hope he dtatabase could be used to keep that kind of information to help with payroll and other report generation.

Q: How many employees need to be working for fuzz to operate all the stations min & max? ( This is used for the setup the constraints ).

A: 1, 1000. [Editors Note: Don't worry about constraints in your LOGICAL model.]

Q: How many live event can be sponsored by fuzz in 1 year min &max for the constraints?

A: zero to infinity (and beyond).

Q: Are there any other entity's you would like us to add to the data base besides songs, playlist, stations?

A: So far the entity's I have gathered will be:

STATION

STATION_TYPE

ARTIST

SONG

TRACK (bridge table for songs and artists)

PLAYLIST

STATION_PROPERTY

EMPLOYEE

EMPLOYEE_TITLE (keeps title and salary info)

COMMAND (what I call the managerial structure)

BOOKING

ROOM_INFO (break out of station property attributes)

Thank you to anyone reviewing it! I know it is a long question!