Reference no: EM13928706
Here is the whole assignment and what I am supposed to do. I am done with everything except the part where I have to run my tables through the SQL program. I need SQL statements for the tables I made. I do not understand how to work with these SQL programs to make my database.
In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize SQLite Database. The SQLite database is a small, lightweight database application, suited for learning SQL and database concepts, or to just explore some database-related ideas without requiring a full-blown database management system (DBMS). Refer to "Supplement: SQL Examples for SQLite Database," for the link to the SQLite Database download and examples.
The working prototype should include the following:
1) Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design.
2) Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
Be sure to run your whole SQL program thru SQLite-CREATEs, INSERTs, & SELECTs-and paste the input text file & the output text file into your Word document like an appendix.
Attachment:- sql.zip
|
What was the significance of liberation theology
: Why were Latin American development programs so often linked to dictatorial regimes? What was the significance of liberation theology and changes within the Catholic Church? What were the new social movements, and what impact did they have on new dem..
|
|
The concept of program reengineering
: Analyze four (4) policy choices of Mayor Schell that were made as part of the strategy for the homeless. Analyze the PreImplementation and Design Strategies of Mayor Schell and interpret four (4) practical outcomes of his choices.
|
|
Do you have relevant sts-related idea or concept
: This paper is necessarily short and thus incomplete. In this light, do you have a relevant STS-related idea or concept to add from which all of us might profit?
|
|
The concept of ethical obligations
: Based on the case study, George Tenet and the Last Great Days of the CIA, in Stillman, Chapter 16, write a 45 page paper in which you
|
|
Design a working prototype of the proposal
: Design a working prototype of the proposal. You will be required to utilize SQLite Database - Provide a brief synopsis analyzing the detailed requirements of your prototype database design.
|
|
Problem regarding the adult learning theory
: What value would it be to know that you were going to be training a class of persons between the ages of 20 and 35? Would it influence the approach you would take? How?
|
|
Creating a context diagram
: Refer again to the information about the Reliable Pharmaceutical Service (RPS) at the end of Chapter 1, "The World of the Information Systems Analyst."
|
|
In what ways might a former slave identify with chief joseph
: After reading Chapter Sixteen, especially "Voices of Freedom", answer the following questions in a three-paragraph response: In what ways might a former slave identify with Chief Joseph and the Nez Perce
|
|
Discuss the various systems development methodologies
: Possession of information can influence decisions in organizations. Discussion how new systems development can change the order of those who control the information and how this disruption may lead to resistance to adopting the new systems.
|