Answered: Can we utilize custom settings and… | bartleby

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 5TD

See similar textbooks

Related questions

Question

Can we utilize custom settings and custom metadata in formula fields? Please explain the difference between custom settings and custom metaData in Salesforce.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

how to eliminate the multivalued attributes?
You are developing an ASP.NET MVC application to be deployed to Microsoft Azure using Entity Framework (EF) for the data model. As you are building the entity connection programmatically, you notice that you need a way to specify the metadata reference. Which class should you use? 1- ProviderConnectionString 2- EntityConnectionStringBuilder 3- SqlconnectionStringBuilder 4- StringBuilder
Normalize the Index metadata connection and explain why you think it would be slower to use.
You will need to create the database tables and choose sensible data types for each column.Make sure to maintain entity and referential integrity, and implement all the above constraints.Since other developers work in parallel on other parts of the system, you will need to strictly follow the above specification to correctly implemented in your database. Otherwise, the other software will not be able to use your database. This means, one needs to be able to rely on all constraints being correct, the spelling of table and column names being as given, and that the data types that you chose will allow for sensible data to be added to the database in the future.For testing purposes, you are asked to insert the data specified below into the tables, but no other data except this.In short:1. You will need to create the tables as specified2. You will need to add the data specified Please use the 3.sql and implement your tables using the sketched CREATE TABLE commands. Add the necessary queries…
ScenarioYou are contracted by BitStream to develop a management system for the TV streamingservices the company provides. Your first task is to design a database structure for thisSystem. Specifically, the database would need to be able to record the following things:● Customers information and account details. This includes customer’ssubscription full details and payment details. Customer’s address needs to berecorded as well. (Hint: you need more than 2 tables)● Movies: information about every movie available for streaming must berecorded. A Movie has many actors and may have more than one director. Amovie may have more than one genre, for example, it can have Drama andAdventure Genres. Movie information needed to be displayed in the systemincludes Title, description, Release year, Language, Genre, classification, mainactors, director, and reviews (hint: reviews should be a separate entity). Recordinformation if the movie is based on a real story or a book.● TV Series: information…
What exactly is metadata? What exactly is metadata in the context of a result set? When is it OK to utilise metadata from a result set?
You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.
What is metadata, exactly? What is the definition of metadata for a result set? When does metadata from a result set come in handy?
Design a survey form of your own. Fill it out as it might have been completed during the database design for Premiere Products. For any questions you have too little information to answer, make a reasonable guess.
Entity Framework (EF) is being used to build an ASP.NET MVC application that will be hosted on Microsoft Azure. You see that you need a mechanism to define the metadata reference when you construct the entity connection programmatically. What's the best kind of class to use? a string representing the connection string between the provider and client 2-Builder of EntityConnectionString 3- SqlconnectionStringBuilder. string-building constructors
You need to create a database for animation activities at a resort: There are customers participating in the activities.Customers' ID, name, surname, age, room number and telephone information are kept. There are animators running the activities.Animators' ID, name, surname, telephone number and area of expertise are kept. Each animator can have more than one specialization. There are two different types of activity. Individual activity and Group activity.Individual activities have ID, activity name, internet connection, participation requirement. Group activities store ID, activity name, internet connection and capacity information. Group activities such as aerobics, surf school, pool games are open to the participation of more than one client and more than one animator. There is only one animator who is also a supervisor for individual activities. An animator supervises only one activity. Many customers can participate in individual activities, but they need a separate scheduled…
Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in…

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

SEE MORE TEXTBOOKS