Which of the following best describes a 'primary key' in a relational database?

A unique identifier for each record in a table

A value that changes frequently

A column that can contain duplicate values

What is the primary purpose of a relational database?

To store and manage data in tables that can be linked together

Which of the following is a key feature of relational databases?

The use of primary and foreign keys to establish relationships

Being unable to handle large amounts of data

Storing data as unstructured files

Requiring no schema to organize data

What is a 'table' in a relational database?

A collection of related data organized in rows and columns

A visual representation of data

An error message in the database

What does a 'foreign key' in a relational database do?

Links two tables together by referencing a primary key in another table

Serves as a primary identifier for each row

Stores an image of the database table

Acts as a backup key for data security

What is the function of a 'join' in SQL?

To combine records from two or more tables based on related fields

To create a new database schema

Which of the following statements is true about relational databases?

They require a predefined schema to define the structure of the data

They automatically determine data relationships without a schema

They can only store numeric data

What is the purpose of normalization in a relational database?

To reduce data redundancy and ensure data integrity

To enhance the graphical interface of the database

To increase data storage capacity

Relational databases

Exploring Relational Databases - Starter Quiz

Databases - Relational and logical operators

Database Management Systems: Data types, Intergrity constraints, entity relationships, relational alegebra

Chapter 7 - Review Data and Decision Making *Glow bus due at midnight, name and student number: answer questions using content in class People have created wonderful things for centuries, and management Management can be traced as far back as 500 bc when the ancient Sumerians used written records to improve government and business activities Why is it important to lean from the past Not to repeat our mistakes Classical management approaches Scientific management Administrative Principles Bureaucratic organisation Behavioural Management Approaches Follett’s Organizations as communities The Hawthorne studies Maslow’s theory of human needs Mcgregor’s Theory x and Theory Y Argyris Personality and organisation Modern Management foundations Organises as systems Contingency thinking Quality management Quantitative and analysis and tools Evidence-based management Contributions Frederick Taylor - Father of Scientific management He noticed that workers often did their jobs with wasted motions and without a constant approach. His resulted in inefficiency and low performance He believed the problem could be fixed if workers were taught to do their jobs in the best ways and ten were helped and guided by supervisors Four guiding principles of scientific management Rules of motion, standardized work and proper working conditions Select workers with the right abilities Train workers and give them incentives Support workers by planning and smoothing the way as they do their work Frank and Lillian Gilbreth Pioneered use of motitono studies as a management tool In one famous case, the gilbreaths cut down the number of motions used by bricklayers adn tripled their productivity Contributions from scientific management Make results-based compensation a performance incentive Carefully design jobs with efficient work methods Carefully select workers with the ability to perform the job Trian workers to execute activities to the best of their abilities Train supervisors to support workers so they can perform jobs to the best of their abilities Classical Management Adiminstative principle (Henro Fayol) 1919, after a career in French industry, Henri F published “adminisration Industrielle et Generale” (General and industrial management) in which we out like his views on the management of organiztion and workers Rules and duties in management Foresight - to complete a plan of action for the future Organization - To provide and mobilize resources to implement the plan Common- to lead, select and evaluate workers to get the best work toward the plan Coordination- to fit diverse efforts together and ensure information is shared and problems solved Control- to make sure things happen according to plan and to take necessary corrective action Classical management Bureacratic organiztion (Max Weber) Max weber (Bureaucrativ organization) - late 19th century German political economist who had a major impact in the fields of management and sociology Bureaucratic Organization An ideal, intentionally rational adn very efficient form of organization Based on the principles of logic, order and legitimate authority Characteristics of BO Clear division of labour Clear hierarchy of authority Formal rules and procedure Impersonality Careers based on merit What are some disadvantages of bureaucracy Takes a long time for problems to become solved bec there are procedures and there is a chain of people in command Having the power Rules have to follow Excessive paperwork or “red tape” Slowness in handling problems Rigidity in the face of shifting needs Resistance to change Employee apathy Behavioural Management Approaches (focus on understanding the elements that affect human behaviour in organisations) Follett’s Organizations as communites Mary park follett contributed to the transition from classical thinking inot behavioural management Groups and human cooperation Groups allow individuales too combine their talents for a greater good Organizations are cooperating “communites” of managers adn workers Managers job is to help people copperate and achive an integration of goals and intrests Forward-looking managment insight: Making every emploee an owner creates a sense of collective responsibility Prescursor of employrr ownership, profit sharing and gain sharing Buniess problems invovle a varity of inter realted factors Prescursor of systems thinking Private profits realtive to public good Precursor of managerial ethics and social respinsibility Hawthorne studies Took place at western electric chicago plan, a tran led by Harvards Elton Mayo set out to learn how econmic incentives and workplace conditions affected workers output Maing objective Intial study examined how ecomoin incentives adn physical conditions affected worker output (productivity) No consistent relationship found During experientmetn they had 2 groups The expertiant groups (impoved wokring ocnditions ) The control group ( no changes to original working conidtions) No consitant relationship found, perfomance in both groups increased even after removing incentives Social setting and human relations Concluded New “social setting” led workers to do good job Good “Human relations” = higher productivity The contect - The Great Depression (1929-1940) Employee attitudes and groups processes Osme thinsf satisifed some workers but not others People resticited output to adhere to groups norms (Avoid layoffs) Lessons from he hawthrone stufirs Social and human concerns are keys to prductivity Hawthrone effect - People who are singled out for special attention perform as expected Maslow’s Theory of human needs Human needs The work of psychologist Abraham Maslow in the area if human “needs,” also has had a major impact in the behavioual apporach to management Maslow’s hierarchy of human needs Self actualization needs Higherst level: need foe self fulfillment to grow and use abilites to fullest and most creative extent Esteem needs Needs fro esteem in eyes of others need for respect, prestige, recognition; need for self esteem, personal sense of competence, mastery Social needs Need for love, affection, sense of belongingness in ones relationship either other people Safett needs Need for security, protection and stability in teh events of day to day life Physiological needs Most basic of all human needs: need for biological maintence; food, water and phydical well being Principles Defict principle: A satidifed need is not a motivator of behaviour Progress principles: A need becomes a motivator once the preceding lower-level need is satisfied Both principles cease to operate at self actulilzation level McGregor’s Theories Thepry x assumes that workers; Dislike work Lack ambition Are irresponsible Resist change Prefer to be led Theoyry y assumes that workers are Willing to work Willing to accept responsibility Capable of self control Capable of self direction Imaginative and creative According to McGregor, Managers create: Self fulfilling prophecies Implications of Theory x and y Theory x managers: Create situations where workers become dependent, passive and reluctant Theory y managers create situations where workers respond with initiative and high performance Central to notions of empowerment and self management Argyris’s theory of adult personality Classical management principles and practices inhibit worker maturation and are inconsistent with the mature adult personality Management practices should accommodate the mature personality: Increasing task responsibility Increasing task variety Using participative decision making Modern Management Foundation Quantitative analysis and Tools Analytics: the use of large data bases and mathematics to solve problems and make informed decision using systematic analysis Organization as systems System Collection of interrelated parts that function together to achieve a common purpose Subsystem A smaller component of a larger system Open systems Organisations that interact with their environment Contingency thinking Tires to maths managerial responses with problem (situation) No “one best way” to manage The “appropriate way to to manage depends on the situations Quality management Qality anc competitive advantafe are linked Total quality managment (TQM) Comprehensive approach to contiou impovment on teh entire organization ISO certification Gloval quality management standards Refine and upgrade quality to meet ISO requirments Evidednce Based Managment Making management decision on “hard facts” about what really works

Stages in the Sale of a Property Stage 1 – Getting to Instruction • Initial contact with the vendor: need to check the following: type of property, contact details of vendor, address of property/Eircode and purpose of the contact - sale or valuation? If a sale, does the vendor need a quick sale? Qualify the lead i.e. is the vendor buying another property? If an investment property, is the tenant in situ? Check if there is a folio number available and confirm the ownership of the property. Schedule the viewing. • Pre-viewing: Set up a file & record all info from initial contact on CRM system. Check the Property Price Register to help get a general idea of property valuation (subject to viewing, helps to display knowledge of area/market and set expectations for the vendor). Nature of property may affect pricing e.g. starter home vs. larger property with vendor seeking to downsize. Consideration for comparables may include similar/same location, size and condition of property, availability and type of parking, layout of property, plot size, orientation of garden, extensions undertaken etc. Nature of market conditions, state of wider economy, cost of capital and availability of credit may also be factors. • Appraisal/viewing: Bring an advertising pack/sales & marketing brochures. Walk through property with client, note nice features/selling points for the brochure, let the client talk about upgrades/specific features of the property. It is very important to listen to the vendor and build rapport. Confirm property details e.g. condition and layout, plot size, orientation of garden. Check for certificates of compliance for any extensions, planning permissions for conversions, right of way if applicable etc. Check if a BER available/provide details for approved assessors. Demonstrate your/the practice’s professional expertise, justify why you should get the instruction, discuss recent local sales and give your potential valuation. Discuss the sales fee, marketing fee and any additional charges e.g. professional photography, drone footage, virtual tours (walkthrough video, Matterport etc.) Ask how the vendor heard about you/your practice and why are they considering you for the sale. Where appropriate offer advice to help vendor increase potential sales price. (If possible, leave with signed Property Services Agreement/Letter of Engagement.) Thank you, send/email market appraisal, any queries/questions do get in touch and let the vendor know that we’ll be in touch in coming days. • Post appraisal – letter sent that pm/next morning with market appraisal; diary note to follow up. Check that market appraisal letter received and check for questions. If did not get sale, find out why not/debrief. If get the sale, email confirmation of instruction. Once PSRA sent and LOE returned signed = stage 2. Other details required – ID, proof of address, proof of ownership/title, solicitor details, BER certificate (refer to assessor if not available). All these should be uploaded to CRM. Stage 2 – Getting to ‘Sale Agreed’ Set up appointment to measure & photograph, note any special features e.g., upgraded kitchen, south-facing garden. Provide ideas for improving sales potential (declutter, painting, tidy garden etc. Check if has vendor potential buyers in mind already e.g., relations, friends, other parties interested. Seek vendor approval for photos/text of brochure. Check for access (tenants in situ/working from home etc) and confirm viewing times. If given a key for viewings – tag it! Check alarm codes & whether a sign is allowed on the property. Bring to market – upload to all websites e.g., daft/my home, in house websites and create window display. Match the property against your internal database of potential purchasers /CRM system. Set up appointments for viewings on CRM or arrange for open viewings. Confirm viewings with vendor & purchaser. Turn on lights, open windows, secure valuables, leave out brochures & business cards, bring viewings sheets to keep record of attendees. Introduce yourself and get attendee details. Let people view the property and address any questions. Point out key features. Record questions to be answered and any feedback from viewers. Ask are they selling property? Let viewers know of offers already received. Lock up/alarm property/close windows. Provide vendor with feedback on viewings - number of viewers / questions raised/overall reaction to property. Offers should be confirmed in writing & upload to on CRM/ offers will be input by bidders onto online bidding platforms ‘Proof of funds’ required for offers in some practices. Successful bidder will be chosen by vendor, who might want quick sale/no chain or prefer the highest bidder. Booking deposit will be sought from successful bidder. The amount varies by practice but must cover fees. Sales Advice Notice/letter should be sent to both solicitors (and may be cc’d to vendor/buyer or notify both that SAN have gone out). Booking deposit receipt should be issued. The BER certificate and report should go to the solicitor. Send requests for docs/info to successful bidder including steps they need to take to progress sale e.g., organise the bank valuation and/or schedule the survey. Once the deposit is paid the property is Sale Agreed, inform other bidders, and update all websites/sales board etc. Stage 3 – Getting to closing Access should be organised for the bank valuation/survey. Stay in touch with both solicitors ‘contract-chasing’ i.e., check when contracts are issued, signed and queries answered. Legal searches undertaken by the solicitors may include checking boundaries, land registry, title, rights of way, compliance certs etc. When contracts are signed 10% purchase price/booking deposit should be sent to the vendor’s solicitor. Once all queries satisfied = drawdown of mortgage/funding, house/life insurance in place. Title deeds will be requested once contract is signed. Decide final closing date. Check that the property taxes have been paid. Check that vendor has vacated the property. When vacant, conduct the final walkthrough and take final readings (MPRNs ). Check with solicitor if the drawn down funds h, and once received the solicitor gives authorisation to the estate agent to release the keys. The agent will do up invoice, send the balance of funds to solicitor and provide gift to purchaser. Finally remove sign, mark as sold on CRM, seek testimonials, upload to social media and close a/c on CRM

Relational

Relational Algebra - Starter Quiz

Related quizzes

Related quizzes