Not Sure Essay

838 words - 4 pages

Assignment 2: Database Design and Data Modeling
Joesph Thomas
18 November 2014
IT525-01 Database Design and Data Modeling
Professor: Jon McKeeby, DSc.
Kaplan University

Question 1. Definitions
a. Business Rule: These are used to provide consistent control of the application’s data access by providing dependencies and relationships between system processes and the application. An example would be when you click print, the application automatically prints to the default printer set by the system instead of allowing you to choose a different source. This type of situation could be setup to prevent data theft.Not exactly based on database design and ERDs.
b. Entity Set (Entity ...view middle of the document...

It can be a Social Security Number or a system generated number. As long as it is unique and does not duplicate.
i. Foreign Key: Within a relational table, this will match the primary key of another table. These are used to cross reference data between tables. For example, Customer Table uses the customer ID for the Primary Key and other fields identify the customers basic data. The Order Table uses the Foreign Key to link each customer to their specific orders.
j. Associative Entity: These are connections that describe relationships between two entities within an Entity-Relationship model where all data is abstract and represented in software engineering. This is not correct.

Question 2 Business Rules
Figure 1. Publisher Database

Explanation of each row in the 4-row format:
(1) Write the entity pair. Author writes Book.
(2) Give one business rule. (An Author must always have at least 1 Book.)
(3) Give the other business rule. (A Book must always have at least 1 Publisher.)
(4) Give the connectivity. (If the connectivity is M:N, the associative entity is ??????.)

Question 3 Primary Key / Foreign Key Placement
The primary key of a table is often named after the table. Example: ISBN-13 would be chosen as the name of the primary key for the Book table.

For each entity set in the table below, give the primary key attribute(s) and the foreign key attribute(s) (if any).
Entity Set Primary Key Attribute(s) Foreign Key Attribute(s)
Publisher Publisher_ID PublisherCountry_ID
Volume Volume_ID ISBN-13
Book...

Other Papers Like Not Sure

Criminal Justice Paper

321 words - 2 pages clarity to. When I revise my papers it make me look at the things I done wrong. Like when I have misspelled words I can correct them and when I have sentences that don’t make sense and I take the out. When I write I make the mistake of writing a lot of write on sentences. I have to make sure that I don’t do that anymore. I have to make sure that I don’t forget the punctuations because I have the habit of not putting them where they belong and

Alc First Phase Essay

282 words - 2 pages 1. Clearly define the ethical problem. Im sure many people would consider not informing their chain of command of this situation given the circumstances(new to the unit and SFC Sharps reputation) and the fact that SFC Sharp is on his way out of the unit. However the ethical dilemma for me is, do I confront him, alert the chain of command or contact the Military Police to launch an investigation. 2. Employ applicable laws and regulations

Queen Elizabeth

640 words - 3 pages , even when it came to the dinner table. I remember she told me I could not have juice until I finished eating all my food. Even to this day I eat mostly all of my food, before I drink any kind of liquids. I tell people do not blame me, blame my mom. She made sure that she would not baby me in any way. My mom made sure to raise a man. When she saw me being picked on one day she made sure I would fight them no matter how big they are. She

Business

1682 words - 7 pages help the organization to make sure that, it will disclose the correct picture of its financial statements in a proper manner in the future (Brookson, 2001). Applicability of GAAP Generally accepted accounting standards and the International Financial Reporting standards are applicable only for corporations therefore; these standards will not apply to the partnership firm. Therefore, the business will not be required to make sure that, it

Entrepreneur

1823 words - 8 pages GAAP In the present situation, the business form selected by the organization is partnership form of business. Generally accepted accounting standards and the International Financial Reporting standards are applicable only for the corporations therefore, these standards will not apply to the partnership firm as in the present situation. Therefore, J& L in the present situation will not be required to make sure that, it complies with the above

How To Essay

623 words - 3 pages preparing to drive a car you need to make sure that everything is safe for the road regardless if it a stick or automatic. When getting in the car make sure the e-brake (Emergency brake) is already in engaged. If not, do so. Make sure the car is in neutral. That means that the car is not in gear, also it another way you can tell is if the shifter can move horizontally back and forth. As you can notice there are 3 pedals. The pedal to the far left is

Module 1 Comp 2

307 words - 2 pages Chris Johns What made me interested in reading the article was the reader pointing out that the public service waring Drink, Drive, Lose isn’t really working nowadays and most states are going to a new program called 24/7 Sobriety. This new program should make sure that people who drink and drive really think about the consequences to their actions and that most states are not playing anymore. I think this article was written for people who

Health Care Communication

723 words - 3 pages .” Good news is always easy to give, but you have to be very careful not to promise something that you cannot guarantee, bad news is both difficult to give and to receive for both the patient and the physician, errors in information can be life changing and are difficult to admit, depending on the circumstances and when saying no to a patient making sure that you explain clearly why you are saying no is very important. Hugman (2010). Communication

Connector Installations

360 words - 2 pages regards to the jacket. There should be as little exposed and untwisted wire as possible to keep the signal strength as high as possible. Make sure to place the White/Blue in the White/Blue spot and not the solid Blue spot. The White/Color wire is not the same as the solid color. * Terminate each wire. After all the wires are in the correct spot and double checked to make sure as little amount of exposed wires will be left as possible, use the

Meeting Ethics

652 words - 3 pages 30 Tips on Meeting Etiquette 1. Be punctual or even better turn up a bit earlier. If this is not possible, arrive at the scheduled time at the latest. But don't be late! If you turn up late, step in quickly and quietly while taking your seat. The less interruption you create the better. 2. When invited to a business meeting, be sure to reply if a reply is requested. 3. Don't expect others to fill you in during or after the meeting. 4

Steps In The Medical Billing Process

974 words - 4 pages does not have medical insurance then the clerks need to determine if the patient needs to be on a payment plan or if they can pay for the service in one payment. Most health facilities require the patient show proof of who is responsible for the bill for the service they are going to receive. Step three for this category is check in patients, this is also done by the front desk. When a patient enters the health clinic the clerks will make sure

Related Essays

Not Sure Essay

2521 words - 11 pages Vau introduces in his floor plans (Ayers). The first feature is “its double-thickness massing of rooms in the corps de logis, and the enormous, double-height, oval Grand Salon which dominates the garden front” (Ayers). The double-thickness massing of the rooms allows for a “more complex configuration as well as individual access to rooms” (Ayers). The great central oval salon represents not only a novel idea, but also a new innovation in France

Entrepreneurship Management My Employees, Buyers And Suppliers Like Working For My Company Because We Have A Lot Of Wins I Am Not Sure How They Will Take It When Our Company

1032 words - 5 pages I best get the advantages of experimentation in terms of innovation while also reduction the costs so that I don’t run the risk of losing my business? Q2. My employees, buyers, and suppliers like working for my company because we have a lot of wins. I am not sure how they will take it when our company begins to have a lot more failures (even if those failures are small)- it is a psychological thing. How can I handle this trade-off? Q3 Even if

Personal Responsibility Essay

1122 words - 5 pages Personal Responsibility GEN 200 September 9, 2013 Carolyn Alston What exactly is personal responsibility? I believe that personal responsibility is to make sure my priorities and assignments will be complete on time and turned in before the due date. Even though I have a son, I may not have much time to do assignments or studying, learning as much as I can is what is important to me so I would be able to find a job for my family. Using

Online Retail Essay

911 words - 4 pages according to what is actually earned. Should teachers assign mostly high grades to students whether or not they earned them with their academic work? Make sure you support your position with reasons, explanations, and examples. 5. Some people argue that technology and modern conveniences have improved our quality of life, while others argue that they have had a negative impact on quality of life. Do you think that technology and modern